# Calculate time difference between two Date & Time values

**URL:** <https://forum.adalo.com/t/calculate-time-difference-between-two-date-time-values/35679>\
**Category:** Get Help\
**Created:** [January 26, 2023, 7:27am UTC](https://forum.adalo.com/t/calculate-time-difference-between-two-date-time-values/35679 "2023-01-26T07:27:26Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![hansravnsfjall](https://avatars.discourse-cdn.com/v4/letter/h/dec6dc/32.png) [@hansravnsfjall](https://forum.adalo.com/u/hansravnsfjall)\
**Post date:** [January 26, 2023, 7:27am UTC](https://forum.adalo.com/t/calculate-time-difference-between-two-date-time-values/35679/1 "2023-01-26T07:27:26Z")

</div>

Hi

I can see this has been asked before, but can´t find a solution. Is it possible to calculate the hours and minutes between two date & time values?

/Hans

---

<div class="post-metadata">

**Author:** ![thisisnickjames](https://avatars.discourse-cdn.com/v4/letter/t/e47c2d/32.png) [@thisisnickjames](https://forum.adalo.com/u/thisisnickjames)\
**Post date:** [January 26, 2023, 9:06am UTC](https://forum.adalo.com/t/calculate-time-difference-between-two-date-time-values/35679/2 "2023-01-26T09:06:35Z")

</div>

Hey, yes it is!

You can work this out by subtracting the older date from the newer date using normal mathematical expressions (-)

This will give you the result in days. You then need to add into your expression to multiply the days by 24 to get hours, or by 24 and then by 60 to get minutes.

({date1} - {date2}) x 24 x 60 (this gives you minutes, for example)

If you want to display a duration, you need to to the above, and then work out and subtract the hours in the same formula.

Hope that helps?

---

<div class="post-metadata">

**Author:** ![hansravnsfjall](https://avatars.discourse-cdn.com/v4/letter/h/dec6dc/32.png) [@hansravnsfjall](https://forum.adalo.com/u/hansravnsfjall)\
**Post date:** [January 30, 2023, 4:21pm UTC](https://forum.adalo.com/t/calculate-time-difference-between-two-date-time-values/35679/3 "2023-01-30T16:21:58Z")

</div>

Hi - thank you for the reply.

Perfekt, i solved it 👍

/Hans

---

<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:** [February 9, 2023, 4:22pm UTC](https://forum.adalo.com/t/calculate-time-difference-between-two-date-time-values/35679/4 "2023-02-09T16:22:56Z")

</div>

Closed on February 9, 2023, 4:22pm UTC

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