# Calculating time between two times

**URL:** <https://forum.adalo.com/t/calculating-time-between-two-times/24155>\
**Category:** Get Help\
**Created:** [March 3, 2022, 10:37pm UTC](https://forum.adalo.com/t/calculating-time-between-two-times/24155 "2022-03-03T22:37:07Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Archer](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/archer/32/17036_2.png) [@Archer](https://forum.adalo.com/u/Archer)\
**Post date:** [March 3, 2022, 10:37pm UTC](https://forum.adalo.com/t/calculating-time-between-two-times/24155/1 "2022-03-03T22:37:07Z")

</div>

Hi All,

I can not figure out how to calculate the Hours and Minutes between two times.

What I need to do is calculate the hours and minutes between a Start Time and an End Time and ideally I need to store this as a variable.

When I tried the simple calculation End Time - Start Time it returned a decimal of 3/24 for 8 hours.

But I need to show the hours and minutes.

 ![Screen Shot 2022-03-04 at 9.31.17 am](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/7/e/7e7737a55ebb1cd640135d5ac121d298975c52db.png)

I will be so grateful for any help on this!

Thanks

---

<div class="post-metadata">

**Author:** ![Yongki](https://avatars.discourse-cdn.com/v4/letter/y/7c8e57/32.png) [@Yongki](https://forum.adalo.com/u/Yongki)\
**Post date:** [March 3, 2022, 11:17pm UTC](https://forum.adalo.com/t/calculating-time-between-two-times/24155/2 "2022-03-03T23:17:35Z")

</div>

Hi @Archer ,

Simply multiply them with 1440 for minutes, INT() first to get only the fraction.

Do the same for hour but get fraction first from the above calculation.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/system/32/40401_2.png) [@system](https://forum.adalo.com/u/system)\
**Post date:** [March 13, 2022, 11:18pm UTC](https://forum.adalo.com/t/calculating-time-between-two-times/24155/3 "2022-03-13T23:18:34Z")

</div>

Closed on March 13, 2022, 11:18pm UTC

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