next up previous contents index
Next: IF Up: A. Function Reference Previous: HMEAN, HARMEAN   Contents   Index


HOUR

Syntax: HOUR(DT)

DT = a date/time value

HOUR returns the hours (0 - 23, where 0 represents midnight) component of the date/time value DT.

Examples:

HOUR(.25) = 6

HOUR(0) = 0

HOUR(.99) = 23

Excel function: HOUR


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