Hi,
Thanks for the reply.
this doesnt seem to have solved it
The problem is i think that the 180 figure represent minutes so what i
need to do is devide this by 60 to give me the number of full hours (in
this case 3).
What both INT and TRUNC are doing is rounding the 2.999999 down to 2 -
although i cant understand why it is taking 180/60 to be 2.99999
instead of 3!
Steven
--
Steven_Archer
------------------------------------------------------------------------
Steven_Archer's Profile:
http://www.excelforum.com/member.php...o&userid=29025
View this thread:
http://www.excelforum.com/showthread...hreadid=487571