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.

Find more posts tagged with

Formulas

Accepted answers

All comments

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?

form.PNG

@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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.