Calculating Total Working Hours between Sign In & Sign Out


I'm facing difficulty of summing up Total Working Hours in the worksheet. I'm working on calculating a simple total working hours for my employee, they just fill in Smartsheet form then the worksheet will calculate it.

I need help on which solution work best on this project. Below I provide the details:

Employee will fill in timesheet form above with a free textbox for time in and time out.

So far I didn't find a proper solution on this

Please let me know what you think the optimal solution is to this problem, I am open to anything!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!