Sum Time Difference in Quarters between 2 Columns

JamesRiosAUS

Is there a way to sum the time difference between two columns

There is two columns "Start Time" and "End Time".

If Start Time = 1800 and End Time = 0600, which falls on the next day. I would need it to calculate 12 hours

If Start Time = 1845 and End Time = 0600, which falls on the next day. I would need it to calculate 11.25 hours

Is this possible?

Find more posts tagged with

Formulas

Time Calculation

Accepted answers

All comments

Paul Newcome

You should be able to find something tucked away in here:

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.