A user friendly time period format using days, hours, minutes and seconds including functions to calculate sums and averages of time periods and more.

Format time periods naturally like:

- 2d 4h 30m 59s
- 3d 12h
- 1h 30m
- 10m 20s

Use the following new functions directly in cells to calculate sum, average, max and min values of a range of dates:

=SUM_DURATION()
=AVERAGE_DURATION()
=MAX_DURATION()
=MIN_DURATION()

We hope you find this to be a much easier way to handle time periods in Google Sheets™.

If you have any questions about the add-on, please contact us here:
https://addonapps.co/contact-us/