# Help with time duration equation between two dates/times

**URL:** <https://community.glideapps.com/t/help-with-time-duration-equation-between-two-dates-times/12821>\
**Category:** Ask for Help\
**Created:** [July 20, 2020, 1:53pm UTC](https://community.glideapps.com/t/help-with-time-duration-equation-between-two-dates-times/12821 "2020-07-20T13:53:00Z")\
**Posts on this page:** 1\
**Showing post:** 8

<div class="post-metadata">

**Author:** ![Tim\_Sullivan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tim_sullivan/32/3461_2.png) [@Tim\_Sullivan](https://community.glideapps.com/u/Tim_Sullivan)\
**Post date:** [July 20, 2020, 10:13pm UTC](https://community.glideapps.com/t/help-with-time-duration-equation-between-two-dates-times/12821/8 "2020-07-20T22:13:30Z")

</div>

Take a look at this post, it may get your creative juices flowing.

> [@Time Sheet App](https://community.glideapps.com/t/time-sheet-app/5333/3):
>
> So I put a small project together that tracks snow plow driver’s times. The Supervisor inputs time in & time out, using the automatic date/time stamp as the “times”. To get the duration, I subtract the start timestamp from the end timestamp - [image] The key to getting a good time elapsed or time worked is to format the final result as “DURATION” in google sheets. Hope this helps you out.

---

_[View the full topic](https://community.glideapps.com/t/help-with-time-duration-equation-between-two-dates-times/12821)._