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?

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
 10.7K Get Help
 63 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!