Calculating the difference in hours:minutes between 2 dates/times

Hello,

I am looking to calculate the different in hours and minutes between two dates and times.

An example would be: Insertion Date/Time - 9/08/23 @ 0800, Removal Date/Time - 9/11/23 @ 1000.

My dates and times are in separate cells. I was able to create a similar workflow in another sheet, but when I try to replicate it in a new sheet, it isn't working out the same.

Thank you!

Kacey

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Below is a link to a thread that deals with time based calculations in Smartsheet.

Depending on when exactly you need this though, there may be an announcement next week at the ENGAGE event regarding time calculations using a dedicated function. 🤞 I personally would wait (if you can) to see what new features get rolled out next week and then explore your options.

If you need it right now 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.