Calculating Time deficit

[Shazz]

I am trying to calculate the difference between times but they are not calculating properly, I am sure it is a format issue but I can not find out what.

Cell Z17 has 44:00 in it and I want to calculate 44-Z17 to show 00:00 in cell AA17 but it shows 04:00 instead.

if a cell Z18 has 42:00 then 44-Z218 should show 02:00 in AA18.

Can anyone help.

Shazz
x

 

[Finalfight40]

Re: Calculating Tim deficet

It looks like where you are typing 44.

44 is not the same as 44:00.

Someone might correct me here but i think what you do is (44/24)-Z17 and similar for your other cell.

I always type times in a cell rather than in the formula.

 

[Finalfight40]

Re: Calculating Tim deficet

Made 1 amendment to the formula above if you didn't see it.