Search…
Resources
Related Links
timeinterval
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.
Last modified 2mo ago
Export as PDF
Copy link