How to calculate time


Hi. What's the formula to calculating time? For example, in one cell, I have my starting point of 6:00am. And in another cell, I have a finish time of 11:00am. What's the formula to calculate time between these two points? Thanks in advance.


  • Cassi
    Cassi ✭✭✭✭✭

    =A2-B2Calculates the difference between the time values in cells A2 and B2.=TIMEVALUE("8:30 PM") - TIMEVALUE("6:40 AM")

    Calculates the difference between the specified times.=TIME(HOUR(A2), MINUTE(A2), SECOND(A2)) - TIME(HOUR(B2), MINUTE(B2), SECOND(B2))

    Calculates the time difference between values in cells A2 and B2 ignoring the date difference, when the cells contain both the date and time values.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!