# Rollup / sum of duration

**URL:** <https://community.glideapps.com/t/rollup-sum-of-duration/73600>\
**Category:** Ask for Help\
**Created:** [May 23, 2024, 2:44pm UTC](https://community.glideapps.com/t/rollup-sum-of-duration/73600 "2024-05-23T14:44:18Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![vedran\_nincevic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vedran_nincevic/32/69441_2.png) [@vedran\_nincevic](https://community.glideapps.com/u/vedran_nincevic)\
**Post date:** [May 23, 2024, 2:44pm UTC](https://community.glideapps.com/t/rollup-sum-of-duration/73600/1 "2024-05-23T14:44:18Z")

</div>

Hi,  
I have a work order app, with Airtable as the base.  
For each work order, in Airtable, there is a column Duration (Ukupno vrijeme)  
 ![CleanERPatUkVrijeme](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/2/622a2a54580d3d20b83b298a3265b807172bf310.png)

In Glide that piece of data is ok (Ukupno vrijeme naloga)  
 ![CleanERPGlideUkVrijeme](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/a/1a594652e675a9f894def22bbd817ce2bfe7eb36.png)

But… in Reports (Izvjestaji), in Total duration Rollup (Ukupno vrijeme ciscenja) I get unusual number (0.1667)  
 ![CleanERPGlideRepTotTime230524](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/5/15818cf078ff93253492923113b6d601851dc6a3.png)  
What would be the simplest and cleanest way to convert that “0.1667” to “4:00” (as hh:mm)?  
Duration of that work order (the last row in Airtable / the last row in Glide table) is 4:00 - 4 hours 00 minutes.  
Thank you very much

---

<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:** [May 23, 2024, 2:53pm UTC](https://community.glideapps.com/t/rollup-sum-of-duration/73600/2 "2024-05-23T14:53:55Z")

</div>

The rollup is giving you a total in days.  
To get that back to a duration in `hh:mm:ss`, you could first use a Math column to convert it to seconds (`R/1*86400`), and then use that in a Format Duration column.

---

<div class="post-metadata">

**Author:** ![vedran\_nincevic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vedran_nincevic/32/69441_2.png) [@vedran\_nincevic](https://community.glideapps.com/u/vedran_nincevic)\
**Post date:** [May 23, 2024, 4:14pm UTC](https://community.glideapps.com/t/rollup-sum-of-duration/73600/3 "2024-05-23T16:14:27Z")

</div>

It worked 🙂  
Thank you very very much

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [May 30, 2024, 4:14pm UTC](https://community.glideapps.com/t/rollup-sum-of-duration/73600/4 "2024-05-30T16:14:54Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.