# Rounding up time

**URL:** <https://community.glideapps.com/t/rounding-up-time/74838>\
**Category:** Ask for Help\
**Created:** [July 11, 2024, 8:57pm UTC](https://community.glideapps.com/t/rounding-up-time/74838 "2024-07-11T20:57:47Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dan\_San](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan_san/32/24085_2.png) [@Dan\_San](https://community.glideapps.com/u/Dan_San)\
**Post date:** [July 11, 2024, 8:57pm UTC](https://community.glideapps.com/t/rounding-up-time/74838/1 "2024-07-11T20:57:47Z")

</div>

I need to calculate the time difference between two dateTimeStamps in hours  
Then I need to round up to the next hour. So if the duration between the times was 2 hours and 1 second, that is 3 hours.

I’m using Date Difference column that gives the answer in days. I then use maths column to multiply by 24 to give me hours.

What is the best/easiest way to now round up.

---

<div class="post-metadata">

**Author:** ![Dan\_San](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan_san/32/24085_2.png) [@Dan\_San](https://community.glideapps.com/u/Dan_San)\
**Post date:** [July 11, 2024, 9:10pm UTC](https://community.glideapps.com/t/rounding-up-time/74838/2 "2024-07-11T21:10:46Z")

</div>

got it…

Maths trunc(jobDur \* 24) + 1

where jobDur is a column calculated by Date Difference in hours

---

<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:** [July 18, 2024, 9:10pm UTC](https://community.glideapps.com/t/rounding-up-time/74838/3 "2024-07-18T21:10:56Z")

</div>

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