Description
Creates a Time from a number.
Syntax
NumberToTime ( timenum )
Arguments
timenum is a 13-digit integer representing a time as hhmmssfffffff.
Remarks
NumbertoTime converts an integer into time in the form hhmmssfffffff. Time is carried out to the millisecond (fff). The remaining places are truncated.
NumbertoTime works with both Time and DateTime values.
Examples
NumberToTime(1234560000000)Returns 12:34:56
NumberToTime(1234561231234)Returns 12:34:56:123