Search…
Resources
Related Links
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)
duration(appointment(date(2021, 3, 27), date(2021, 3, 29)))
Result: 1 Days 23:00 (Instead of 2 days as perhaps expected due to the time change on March 28, 2021.

See also

appointment, which converts given time-related values to an appointment.
Last modified 2mo ago
Export as PDF
Copy link