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!!

Sum Without Error

Sum Without Error:

If the Column contains error then summing up with formula
=sum(range), will show an error too.

First, get all the error as blank and then sum it.

For that use array function, 

{=sum(iferror(range,""))}

For array function write in formula bar

=sum(iferror(c4:c17,"")) and press ctrl+shift+enter

Similarly you can do this with average, count, max or min function

Thanks