Time Tracking Formula

NWilson

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.

Michael Culley

Could you show us a picture so we have a better idea of what you need?

Are you just trying to figure out a formula to calculate hours based on time in and time out?

NWilson

Incidents.PNG

Member List.PNG

form.PNG

Paul Newcome

@NWilson There should be something you can use in the below linked thread. I think it is up to 12 pages now, so it may take just a little bit of digging though.

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