Date and Time Commands

TIMER
TIMER2


TIMER

Converts the input in sec­onds to an hour based timer

Format: TIMER ( sec­onds , pre­ci­sion ) OR TIMER ( sec­onds , format )

Arguments: sec­onds: the time in sec­onds you wish to con­vert to hours:mins:seconds pre­ci­sion: the num­ber of dec­i­mal places to show. A val­ue for­mat: a string which uses the date for­mat stan­dard link to out­put the string. Any dates will be today

Available: Available for all win­dows Version: 9 and later

Examples:
TIMER ( 3601.123,0 ) will return 1:00:01
TIMER ( 3601.123,2 ) will return 1:00:01.12
show TIMER ( 3601.123, HH.mm.ss a” ) will show 01.00.01 AM


TIMER2

Converts the input in sec­onds to a minute based timer

Format: TIMER2 ( sec­onds , precision )

Arguments: sec­onds: the time in sec­onds you wish to con­vert to mins:seconds pre­ci­sion: the num­ber of dec­i­mal places to show. A value

Available: Available for all win­dows Version: 9 and later

Examples:
TIMER2 ( 3601.123,0 ) will return 60:01
TIMER2 ( 3601.123,2 ) will return 60:01.12