Hi
Thanks for the answers. if I do this, then format 6.8611 to time.
"Days, hours, minutes and seconds" , I get this 06 20:40:00. Should I
not get this 06 06:53:20 ( 6 days - 6 x 8 hour days = 48hours, 6 hours
- 54 hours minus 48 hours=6, 53 minutes and 20 seconds). To format the
cell I put in custom number - dd hh:mm:ss . Is this right.
Liam


--
billcar2005
------------------------------------------------------------------------
billcar2005's Profile: http://www.excelforum.com/member.php...o&userid=35113
View this thread: http://www.excelforum.com/showthread...hreadid=548690