next up previous contents index
Next: TIMEVALUE Up: A. Function Reference Previous: TERM   Contents   Index


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


next up previous contents index
Next: TIMEVALUE Up: A. Function Reference Previous: TERM   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003