How to calculate time
Options
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.
Tags:
Answers

=A2B2
Calculates 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
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!