Time Difference in Decimal

Time Difference in Decimal

Lots of time, we need to calculate the difference of time where we mistakes a lot.

You can simply subtract the difference, which is correct but not very useful or meaningful.

Here, I covered the time difference specifically to show the minutes part.

1) you can prefer example 30 minutes, which is 00:30. When you sum up two 30 minutes , it will be 60 minutes which is obvious an hour, or

2) you can prefer half an hour in 0.50 format. So, when you sum two half an hour it will show complete one hour (i.e 1)

I personally prefer 2nd one, which is easier for me for further calculations.

Option first formula: TEXT(C2-B2,"hh:mm:ss")
Option second formula: MOD(C2-B2,1)*24

Thank you!!