0
duration
To return the duration of an appointment
This function calculates the duration of an appointment for you, i.e. the time between the start and the end. The result is shown in hours and minutes.
If the duration is longer than 24 h, the days are shown additionally. There is no conversion from days to weeks, months, or years.
Summer and winter time are considered.
Syntax
duration(appointment)
Return
timeinterval
Examples
Your result format may be different depending on your settings.
duration(holiday1)
Result: 4 Days 9:00 (with holiday1: 05/24/2021 09:00 - 05/28/2021 18:00 (US))
duration(appointment(date(2021, 3, 27), date(2021, 3, 29)))
Result: 2 Days
See also
appointme
nt
, which converts given time-related values to an appointment.
Reply
Content aside
Related Articles