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

  • brianschmidt
    brianschmidt ✭✭✭✭✭
    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!