Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cal Bal Hr & Min
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) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cal Bal Hr & Min
=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 "TSK" wrote in message ... 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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|