# Adding up duration times

**URL:** <https://community.glideapps.com/t/adding-up-duration-times/58559>\
**Category:** Ask for Help\
**Created:** [February 28, 2023, 3:26am UTC](https://community.glideapps.com/t/adding-up-duration-times/58559 "2023-02-28T03:26:06Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jason\_Palmer1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jason_palmer1/32/43557_2.png) [@Jason\_Palmer1](https://community.glideapps.com/u/Jason_Palmer1)\
**Post date:** [February 28, 2023, 3:26am UTC](https://community.glideapps.com/t/adding-up-duration-times/58559/1 "2023-02-28T03:26:06Z")

</div>

I have used math to convert dates into durations.  
I also stitched together the hour and minute calculations with a template column.  
I want to add multiple durations for hours and minutes per user.  
Using a relation and lookup for each user I am able to gather up the multiple durations for each individual but I am unable to ROLLUP and SUM due to the column being a template rather than a number.  
Please advise.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [February 28, 2023, 3:34am UTC](https://community.glideapps.com/t/adding-up-duration-times/58559/2 "2023-02-28T03:34:30Z")

</div>

Rollup the math column instead of the template column, and then convert the rollup value for display.