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.