Automating a way of understanding time difference when start and end time are in the same column.

Jon Brown
Jon Brown ✭✭✭✭
edited 12/09/19 in Formulas and Functions

Hi everyone,

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.

Annotation 2019-11-12 132930.jpg


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!