You need to format the result cell as [h]:mm

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ChristopherM"
wrote in message
news:ChristopherM.26xkuz_1146154502.0352@excelforu m-nospam.com...

Thanks for your help - the only problem is that the hours has to be less
than 24 for it to work. If I enter 35, it treats the value as 5!


--
ChristopherM
------------------------------------------------------------------------
ChristopherM's Profile:
http://www.excelforum.com/member.php...o&userid=23564
View this thread: http://www.excelforum.com/showthread...hreadid=536777