NumberToTime

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