Num2Time

Returns a time string, given a number of milliseconds from the epoch.

Syntax

Num2Time(n [,f [, k ]])

Parameters

Parameter

Description

n

An integer representing the number of milliseconds.

If n is invalid, the function returns an error.

f (Optional)

A time format string. If you do not include a value for f, the function uses the default time format H:MM:SS A.

k (Optional)

A locale identifier string that conforms to the locale naming standards. If you do not include a value for k, or if k is invalid, the function uses the ambient locale.

The function returns a value of 0 if any of the following conditions are true:

The format of the given time does not match the format specified in the function.
Either the locale or time format supplied in the function is invalid.

Insufficient information is provided to determine a unique time since the epoch (that is, any information regarding the time is missing or incomplete.

Examples

The following expressions illustrate using the Num2Time function:

Expression	Returns
`Num2Time(1, "HH:MM:SS")`	`00:00:00` in Greenwich, England and `09:00:00` in Tokyo.
`Num2Time(65593001, "HH:MM:SS Z")`	`13:13:13` EST in Boston, U.S.
`Num2Time(65593001, "HH:MM:SS Z", "de_DE")`	`13:13:13 GMT-05:00` to a German-Swiss user in Boston, U.S.
`Num2Time(43993001, TimeFmt(4, "de_DE"), "de_DE")`	`13.13 Uhr GMT+01:00` to a user in Zurich, Austria.
`Num2Time(43993001, "HH:MM:SSzz")`	`13:13+01:00` to a user in Zurich, Austria.