tim()

Syntax

tim(number[,timeformat])

Description

Converts the specified number value to a time determined by the timeformat argument and returns the result; #FT is used as the time formatting string if the second argument is not specified.

If the first argument is already a date/time, its format is changed to the format given by the second argument.

The #FT string defaults to 'H:N' and so tim(number) takes number to be a number of minutes. If you supply a format string such as 'N.S', number will be taken as a number of seconds.

With a second argument, tim() is equivalent to dat() with two arguments. The format string determines how the conversion is carried out.

Example

Calculate lTime as  tim(1)
# returns 00:01 when #FT is H:N (the default)  

Calculate lTime as  tim(950)
# returns 15:50  

Calculate lTime as  tim(950,'H:N.S')
# returns 00:15.50, that is 950 seconds