Cal Bal Hr & Min

[TSK]

Can someone help cos I am very new in excel but I need this formula to be in
place to for work.

Assuming one in total there is 720 Hours

Cell A1 - 0:20

Cell A2 - I would prefer to have it formula but I just dun get it right
(Answer for cell A2 should 719:40)

 

[Peo Sjoblom]

=B1-A1

where B1 holds 720:00

make sure the format is [hh]:mm

if you have 720 and not 720:00 then use

=(B1/24)-A1


--


Regards,


Peo Sjoblom