Hi
Just a quick question one of my calculations returns a length of time
in hours in a decimal format. I was wondering if there was a way to
format the cell so that for example if the figure 53.5 was returned
then the cell would display the value 53:30
(for 53 hours 30 minutes). the best that i can get so far is using "#
?/60" to return:
53 30/60
This isn't as neat as i would like. I have tried the date/time
formatting options but they only seem to return things like 12:00:00.
Any ideas?


--
dziw
------------------------------------------------------------------------
dziw's Profile: http://www.excelforum.com/member.php...o&userid=10422
View this thread: http://www.excelforum.com/showthread...hreadid=467798