change

Columns("I").NumberFormat = "###0.00"
to

Columns("I").NumberFormat = "hh:mm"

and remove the "*24" from each of the formulas.

--
Regards,
Tom Ogilvy


"chin_un_len"
wrote in message
...

Hi Topper,

I was wondering if you could help out once more, the code you gave me
works great but I need to change it a bit, when the time is calculated
and the conditions are checked, it gives the time in decimal, is it
posible for example when it checks for the 120 hours to give the date
the 120 hours are met and not the decimal?

Your help in this matter will be greatly appreciated.


--
chin_un_len
------------------------------------------------------------------------
chin_un_len's Profile:
http://www.excelforum.com/member.php...o&userid=30914
View this thread: http://www.excelforum.com/showthread...hreadid=505938