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 -
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.
