AgileApps Support Wiki Pre Release

TIMEVALUE

From AgileApps Support Wiki
Revision as of 19:05, 27 August 2009 by imported>Evelyn
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

The TIMEVALUE function creates a time from text in 24 hour format.

Syntax
TIMEVALUE (expression)
Return
Date in the format defined by Date Format
Range, depending on format
24-hour format: [0-23]:[0-59]
12-hour format: [1-12]:[0-59] [AM/PM]


Example
TIMEVALUE('01:57') = '01:57:00'
TIMEVALUE('01:57 pm') = '13:57:00'
TIMEVALUE('15:57') = '15:57:00'