Time Formula Question
I am trying to capture the time it took for an email to be sent and the result is a decimal. What is a good formula to use to capture the result in a time format?
I want the result to be this format:
Appreciate the help.
Best Answer
-
It looks like your "Time to resolve" column calculates the percentage of a day (24 hours) that it takes to resolve. If this is consistent, you could use that column as a basis to formulate your Total Time. Here's the formula I would use in your "Total Time" column:
=ROUNDDOWN([Time to resolve]@row * 24) + ":" + (ROUNDDOWN(([Time to resolve]@row * 24 - ROUNDDOWN([Time to resolve]@row * 24)) * 60))
Answers
-
How exactly are you generating a decimal? Does that decimal represent a portion of a day, a portion of an hour, or some other scale?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
It looks like your "Time to resolve" column calculates the percentage of a day (24 hours) that it takes to resolve. If this is consistent, you could use that column as a basis to formulate your Total Time. Here's the formula I would use in your "Total Time" column:
=ROUNDDOWN([Time to resolve]@row * 24) + ":" + (ROUNDDOWN(([Time to resolve]@row * 24 - ROUNDDOWN([Time to resolve]@row * 24)) * 60))
-
@brianschmidt that worked perfect. thank you so very much!
-
Great! Glad that worked for you:)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 377 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!