Time Tracking Formula

I need to track the hours of our paid on call fireman. I wanted to be able to create a form that asks the Incident number, date, time in, time out, and total time. For each incident, I selected the members that were on the call. On another sheet? I have each member listed out and a breakdown of the total hours for each member divided down to the month.

I have created two sheets and the form but I cannot figure out a formula to add up the hours.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!