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

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


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

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999