Cal Bal Hr & Min

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TSK - 05 May 2008 16:01 GMT

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 to this Message

Peo Sjoblom - 05 May 2008 16:06 GMT

=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

Signature

Regards,

Peo Sjoblom

> Can someone help cos I am very new in excel but I need this formula to be
> in
[quoted text clipped - 6 lines]
> Cell A2 - I would prefer to have it formula but I just dun get it right
> (Answer for cell A2 should 719:40)

Reply to this Message