=INT(A1/60)&"hrs "&MOD(A1,60)&"mins"

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Gonzo" wrote in
message ...

Thanks for your help, i got the k/hr thing working, pretty simple.. i
should have guessed :P

But i still cant get the time to work to convert 3 digit mins to a
time.. like 124 to show as " 2 hrs 04 mins"

Can you please clarify?

Again my file in question is here
http://users.bigpond.net.au/adams_st...ng%20stats.xls

The password for the protection is not set.. just turn it off..

Thanks Again..


--
Gonzo
------------------------------------------------------------------------
Gonzo's Profile:
http://www.excelforum.com/member.php...o&userid=28943
View this thread: http://www.excelforum.com/showthread...hreadid=486786