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
Check out the Formula Handbook template!