 Formula Engine Reference Guide |
|
Back to Class Index
TIME(H, M, S)
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.
Parameters
H
hour
M
minute
S
second
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