Investment Studio > Expressions > Functions > Date & Time > TIMEVALUE

time timevalue(string argument)

Returns the time (a float in the range [0, 1[ interpreted as a fraction of a whole day) specified by the argument string.

The string must contain two or three numbers, separated by the system-defined time separator character (see the Regional Settings applet in the Windows Control Panel), optionally followed by an AM or PM indicator.

The numbers represent hour, minute, and (optionally) second, in that order. If the time is followed by AM or PM, it is assumed to be in 12-hour clock format. If no AM or PM indicator is included, the time is assumed to be in 24-hour clock format.

Note that automatic type conversion often makes the use of this function redundant.

Example

With standard US time format settings,

=timevalue("3:36 AM")

equals 0.15 (if interpreted as a plain float).

See also hour, minute, month, now, second, time, value.