TIME

**Syntax:** **TIME( H, M, S)**

*H* = hour

*M* = minute

*S* = second

**TIME** returns the time value represented as a fraction of
a day, starting at midnight. *H* must be between 0 and 23,
and *M* and *S* must be between 0 and 59.

**Examples:**

**TIME**(12, 0, 0) = 0.5, where 0.5 represents half of a day,
which is noon

**TIME**(8, 45, 46) = 0.36511574

**HOUR**(**TIME**(C1, D1, E1)) = 13, where C1 = 13, D1 = 40, and
E1 = 2

**Excel function:** TIME

Grey Trout Software

02 March 2003