# Time Sheet App

**URL:** <https://community.glideapps.com/t/time-sheet-app/5333>\
**Category:** Ask for Help\
**Created:** [March 10, 2020, 4:12pm UTC](https://community.glideapps.com/t/time-sheet-app/5333 "2020-03-10T16:12:38Z")\
**Posts on this page:** 1\
**Showing post:** 3

<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:** [March 10, 2020, 4:50pm UTC](https://community.glideapps.com/t/time-sheet-app/5333/3 "2020-03-10T16:50:57Z")

</div>

> [@kyleheney](#):
>
> For the time sheet app, I’ve thought about creating one too. One thing that became a bit annoying was that there is no “Time” component — just date/time… so users would have to enter both the date and time each time they enter a new value. On our time sheets, staff enter start time, break time, lunch time, end time, so they’d have to enter the date each time as well (not just the time).

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](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/3/3d213264281907cdc99a1996e454b24448104d92.png)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/1c522b5992fd9901e6917e8eec08642f7a30b23a.png)

The key to getting a good time elapsed or time worked is to format the final result as “DURATION” in google sheets.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/e/edfc3d232560c11a5ac9df9e3a878999cea44921.png)

Hope this helps you out.

---

_[View the full topic](https://community.glideapps.com/t/time-sheet-app/5333)._