Using a form to get start and end time from employee

chrispad

Hello

I am trying to use a form to collect start time and end time from a group of employees. Once the sheet has been populated with the data from the form, how to I automate the total time spent?

Paul Newcome

Take a look through this thread. Page 16 has a way to use the new TIME function.

https://community.smartsheet.com/discussion/68947/formulas-for-calculating-time