Help with time duration equation between two dates/times

[Tim_Sullivan]

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

Time Sheet App

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] [image] The key to getting a good time elapsed or time worked is to format the final result as “DURATION” in google sheets. [image] Hope this helps you out.