Automating a way of understanding time difference when start and end time are in the same column.
We are looking at using a smartsheet solution to understand how much time employees on our production lines are spending working on certain lines.
I created a separate sheet for each production line (we have 12 production lines) and I am using QR codes scanned via a smartsheet form (Quick for employees to enter data) to enter start and end time. There is a start time QR code and an end time QR code.
My issue is the start and end times are in the same system created column so its not easy to create a formula to see how much time someone spent on the line.
Here is a picture from my sheet with example data.
Help Article Resources
Check out the Formula Handbook template!