Cal Bal Hr & Min

  • Thread starter Thread starter TSK
  • Start date Start date
T

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)
 
=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
 
Back
Top