To convert a given time-related value to a time interval, i.e. a duration

To convert a given time-related value to a time interval, i.e. a duration.

If the value is a number, it represents the duration in milliseconds.

Unlike the function duration(), which returns the interval between 2 date values, this function specifies only the duration itself.

Syntax

timeinterval(any)

More about any >

Return

timeinterval

Examples

timeinterval(60000)

Result: 0:01

timeinterval(time(1, 30))

Result: 1:30

time(1,30) is the time 01:30 AM, but with the function, you make it a duration of 1 h 30 min.

See also

duration which returns the duration of an appointment.