Forum Discussion
How to calculate the total hours from a specific date and time to another specific date and time
Hello,
Please help me learn how to calculate the total hours from a specific date and time to another specific date and time. For example, what is the total amount of hours from 1/8/23 6:30 PM to 1/9/23 9:39 AM?
Much appreciated,
Darryl
1 Reply
Let's say 1/8/23 6:30 PM is in cell B2 and 1/9/23 9:39 AM in cell C2.
The time difference is =C2-B2
Format the cell with the formula with the custom format [h]:mm
If you want the time difference as decimal hours (e.g. 15.15), use =25*(C2-B2)
Format the cell with the formula as General or as Number.
