# Calculer le nombre d heure entre deux horaires

**URL:** <https://community.glideapps.com/t/calculer-le-nombre-d-heure-entre-deux-horaires/61805>\
**Category:** Ask for Help\
**Created:** [May 16, 2023, 8:11am UTC](https://community.glideapps.com/t/calculer-le-nombre-d-heure-entre-deux-horaires/61805 "2023-05-16T08:11:33Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![theo\_180280](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/theo_180280/32/50049_2.png) [@theo\_180280](https://community.glideapps.com/u/theo_180280)\
**Post date:** [May 16, 2023, 8:11am UTC](https://community.glideapps.com/t/calculer-le-nombre-d-heure-entre-deux-horaires/61805/1 "2023-05-16T08:11:33Z")

</div>

Hi i want to calcul the number hour between two hour exempl day 15 April at 14h00 and 16April at 11h00.thanks

---

<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 16, 2023, 8:23am UTC](https://community.glideapps.com/t/calculer-le-nombre-d-heure-entre-deux-horaires/61805/2 "2023-05-16T08:23:53Z")

</div>

You can use a Math column with the formula `End - Start`.  
This will give you a duration in the format HH:MM:SS

If you only want hours, then you could instead use the following formula: `Trunc((End - Start)*24)`

---

<div class="post-metadata">

**Author:** ![theo\_180280](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/theo_180280/32/50049_2.png) [@theo\_180280](https://community.glideapps.com/u/theo_180280)\
**Post date:** [May 16, 2023, 8:36am UTC](https://community.glideapps.com/t/calculer-le-nombre-d-heure-entre-deux-horaires/61805/3 "2023-05-16T08:36:31Z")

</div>

Hi, it s not good look

 ![IMG_20230516_093517](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/8/e85b687e6e982bb94b6f6b22e4a90261af15f35b.jpeg)  
normaly the good answer is 7h00

---

<div class="post-metadata">

**Author:** ![theo\_180280](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/theo_180280/32/50049_2.png) [@theo\_180280](https://community.glideapps.com/u/theo_180280)\
**Post date:** [May 16, 2023, 8:44am UTC](https://community.glideapps.com/t/calculer-le-nombre-d-heure-entre-deux-horaires/61805/4 "2023-05-16T08:44:18Z")

</div>

![IMG-20230516-WA0001](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/a/0a1274b7e5f21b697dbe5e76925594378413c246.jpeg)

---

<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 16, 2023, 10:00am UTC](https://community.glideapps.com/t/calculer-le-nombre-d-heure-entre-deux-horaires/61805/5 "2023-05-16T10:00:24Z")

</div>

Check your formula replacements. It looks like you have the Start and End reversed.

---

<div class="post-metadata">

**Author:** ![theo\_180280](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/theo_180280/32/50049_2.png) [@theo\_180280](https://community.glideapps.com/u/theo_180280)\
**Post date:** [May 16, 2023, 1:21pm UTC](https://community.glideapps.com/t/calculer-le-nombre-d-heure-entre-deux-horaires/61805/6 "2023-05-16T13:21:36Z")

</div>

Yes i check but it s the something’s with that-

---

<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 16, 2023, 1:27pm UTC](https://community.glideapps.com/t/calculer-le-nombre-d-heure-entre-deux-horaires/61805/7 "2023-05-16T13:27:02Z")

</div>

In your last screen shot the result is -17 hours. This suggests that your formula is “Arrive - Depart”. It should be the other way around. ie. “Depart - Arrive”.

---

<div class="post-metadata">

**Author:** ![Marc-Olivier](https://avatars.discourse-cdn.com/v4/letter/m/ac91a4/32.png) [@Marc-Olivier](https://community.glideapps.com/u/Marc-Olivier)\
**Post date:** [May 16, 2023, 1:38pm UTC](https://community.glideapps.com/t/calculer-le-nombre-d-heure-entre-deux-horaires/61805/8 "2023-05-16T13:38:04Z")

</div>

Ton heure d’arrivée 5h est avant ton heure de départ 22h puisque c’est le même jour 16 mai. C’est pour cette raison que tu as -17h.  
@Darren_Murphy the arrival date is before the departure date 😉

---

<div class="post-metadata">

**Author:** ![theo\_180280](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/theo_180280/32/50049_2.png) [@theo\_180280](https://community.glideapps.com/u/theo_180280)\
**Post date:** [May 16, 2023, 2:07pm UTC](https://community.glideapps.com/t/calculer-le-nombre-d-heure-entre-deux-horaires/61805/9 "2023-05-16T14:07:49Z")

</div>

Thanks

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [May 16, 2023, 2:07pm UTC](https://community.glideapps.com/t/calculer-le-nombre-d-heure-entre-deux-horaires/61805/10 "2023-05-16T14:07:50Z")

</div>

Time travel!

---

<div class="post-metadata">

**Author:** ![theo\_180280](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/theo_180280/32/50049_2.png) [@theo\_180280](https://community.glideapps.com/u/theo_180280)\
**Post date:** [May 16, 2023, 7:11pm UTC](https://community.glideapps.com/t/calculer-le-nombre-d-heure-entre-deux-horaires/61805/11 "2023-05-16T19:11:11Z")

</div>

Ok now its ok but i want to convertir day hour in minutes for example. 72:00:00 in minute before 24hours it s good but after it s not good

 ![16842642262401349642370802716169](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/7/a7f04ab88ca2843b4d6c4d8941ae498a865f5897.jpeg)