# I want to calculate the difference in time between two date and time columns

**URL:** https://community.glideapps.com/t/i-want-to-calculate-the-difference-in-time-between-two-date-and-time-columns/86283
**Category:** Ask for Help
**Created:** [February 7, 2026, 5:38pm UTC](https://community.glideapps.com/t/i-want-to-calculate-the-difference-in-time-between-two-date-and-time-columns/86283 "2026-02-07T17:38:16Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![David\_Guinee](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_guinee/32/87223_2.png) [@David\_Guinee](https://community.glideapps.com/u/David_Guinee)
#### Post date: [February 7, 2026, 5:38pm UTC](https://community.glideapps.com/t/i-want-to-calculate-the-difference-in-time-between-two-date-and-time-columns/86283/1 "2026-02-07T17:38:16Z")

</div>

Help please? I am trying to get Minutes until next break to populate by calculating the difference between the current time and the time of the next break. I a have used tools I can see but they don’t seem to work? Any help with this would be appreciated I am an absolute beginner - CoPilot has been helpful to a degree but keeps referring me to methods of old versions of glide. Once I have this sorted the rest of my app should be sorted.

 ![Screenshot 2026-02-07 at 17.35.22](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/5/953a0105b29ecbb10e57b4c14677c21183c8df4c.png)

---

<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: [February 7, 2026, 6:52pm UTC](https://community.glideapps.com/t/i-want-to-calculate-the-difference-in-time-between-two-date-and-time-columns/86283/2 "2026-02-07T18:52:20Z")

</div>

Use a math column: (End - Start) \* 1440

---

<div class="post-metadata">

### Author: ![savvvit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/savvvit/32/72068_2.png) [@savvvit](https://community.glideapps.com/u/savvvit)
#### Post date: [February 8, 2026, 5:13pm UTC](https://community.glideapps.com/t/i-want-to-calculate-the-difference-in-time-between-two-date-and-time-columns/86283/3 "2026-02-08T17:13:52Z")

</div>

To clarify @Darren_Murphy answer.  
(End - Start) is time difference in DAYS.  
(End - Start) \* 24 is time difference in HOURS.  
(End - Start) \* 24 \* 60 is time difference in MINUTES.  
(End - Start) \* 24 \* 60 \* 60 is time difference in SECONDS.  
…

---

<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: [February 15, 2026, 5:14pm UTC](https://community.glideapps.com/t/i-want-to-calculate-the-difference-in-time-between-two-date-and-time-columns/86283/4 "2026-02-15T17:14:12Z")

</div>

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