Microsoft Office Tutorials and References
In Depth Information
Keeping TIME
Keeping TIME
You can use the TIME function to combine hours, minutes, and seconds into
a single usable value. Figuring out the serial number representation of a
particular moment in time isn’t easy. Luckily, the TIME function does this for
you. You provide an hour, minute, and second, and TIME tells you the serial
value. To do this, follow these steps:
1. Select the cell where you want the result displayed.
2. Enter =TIME( to begin the function entry.
3. Click the cell that has the hour (0–23), or enter such a value.
4. Enter a comma ( ,).
5. Click the cell that has the minute (0–59), or enter such a value.
6. Enter a comma ( ,).
7. Click the cell that has the second (0–59), or enter such a value.
8. Enter a ), and press Enter.
The result is a decimal serial number, or a readable time if the cell is
formatted properly.
You should be aware that the minute and second values “wrap.” A value of
60 or greater for seconds wraps to the next minute — for example, 75
seconds is interpreted as 1 minute 15 seconds. Likewise, a minutes value of 90 is
interpreted as 1 hour 30 minutes. Hours wrap too — an hours value of 26 is
interpreted as 2 a.m.
Text to Time with TIMEVALUE
If you enter a time in a standard format into a cell, Excel recognizes it as a
time. It is converted to a serial number, and the cell is assigned the default
time format. If, however, you are pasting or importing data from another
application, you may encounter times in text format, such as “2:28 PM”.
You can convert these to a time serial number using the TIMEVALUE
function. Here’s how:
1. Select the cell where you want the result displayed.
2. Enter =TIMEVALUE( to begin the function entry.
Search JabSto ::




Custom Search