Excel - Time Calculation

What if you want to calculate a time difference in hours as a real value? I have seen some rather complex solutions to this, but a simple formula is all that is necessary.

If cells cell A1 and B1 contain the earlier and later times respectively, with the cells formatted as time, the difference between them can be retrieved using the following formula in a cell formatted as a number:

=(A1-B1) * 24

If you want the difference as hours and minutes, format the cell as a time cell, and leave out the ‘* 24’

Comments are closed.