Microsoft Office Tutorials and References
In Depth Information
Using TIME to Calculate a Time
Figure 11.39.
Figure 11.39. The formulas in column D use
functions to cal-
culate an Excel serial number from three arguments.
The formulas in column D use DATE
DATE oor TIME
TIME functions to cal-
culate an Excel serial number from three arguments.
Using
Using TIME
TIME to Calculate a Time
to Calculate a Time
The TIME function is similar to the DATE function. It calculates a time seri-
al number given a specific hour, minute, and second.
Syntax
=TIME(hour,minute,second)
The TIME function returns the decimal number for a particular time. The
decimal number returned by TIME is a value ranging from 0 to 0.
999988425925926, representing the times from 0:00:00 (12:00:00 a.m.) to 23:59:59
(11:59:59 p.m.). This function takes the following arguments:
hour
hour This is a number from 0 to 23, representing the hour.
Search JabSto ::




Custom Search