TIMEVALUE Function
Function Type | Predefined function | |
Syntax | TIMEVALUE( <timeString> ) | |
Description | Returns a Time data type corresponding to <timeString>. | |
Argument | Description | |
<timeString> | String containing the time in "HH:mm:ss" format. <timeString> is a string representing a time from 00:00:00 through 23:59:59. Valid times can be entered using a 24-hour clock. | |
An error occurs if <timeString> contains invalid date information. | ||
Returns | Time | |
Example | This example returns the date/time typed value of "7:30:00" a.m. from the string "7:30:00". TIMEVALUE("7:30:00") | |
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*