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)
Return
timeinterval
Examples
Result: 0:01
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 updated