TIMEVALUE
From LongJump Support Wiki
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'