=TIME(HOUR(A2), MINUTE(A2), SECOND(A2)) - TIME(HOUR(B2), MINUTE(B2), SECOND(B2))Ĭalculates the time difference between values in cells A2 and B2 ignoring the date difference, when the cells contain both the date and time values. =TIMEVALUE('8:30 PM') - TIMEVALUE('6:40 AM')Ĭalculates the difference between the specified times.
Depending on you data structure, the actual time difference formula may take various shapes, for example: FormulaĬalculates the difference between the time values in cells A2 and B2.
