next up previous contents index
Next: TODAY Up: A. Function Reference Previous: TIME   Contents   Index


TIMEVALUE

Syntax: TIMEVALUE(S)

S = a string value

TIMEVALUE returns the corresponding time value for a given string value S. The function interprets the times specified in the following formats:

HH:MM:SS AM or PM (1 $<$= HH $<$=12)
HH:MM:SS (0 $<$= HH $<$=23)
HH.MM.SS (0 $<$= HH $<$=23)
HH,MM,SS (0 $<$= HH $<$=23)
HHhMMmSSs (0 $<$= HH $<$=23)

The first format is the international 12-hour AM/PM time format. All others are international 24-hour time formats.

In all formats the seconds (SS) may be omitted, in which case they default to 00.

In all formats the hours may be specified with 1 or 2 digits, while the minutes (MM) and seconds (SS) must be 2 digits.

The following are equivalent:

TIMEVALUE(``12:55:00 AM'')

TIMEVALUE(``12:55 am'')

TIMEVALUE(``00:55:00'')

TIMEVALUE(``00:55'')

TIMEVALUE(``00, 55, 00'')

TIMEVALUE(``0.55.00'')

TIMEVALUE(``0h55m00s'')

The result is 0.038194444

Excel function: TIMEVALUE


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