First one

Format the cell as General"K/hr"

Second one

use =IF(A199,INT(A1/100)&"h ","")&MOD(A1,100)&"m"

--

HTH

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


"Gonzo" wrote in
message ...

Hi Guys,
Can someone help me display a number from a formular as kimometers
and kilimoters per hour, like "21k/hr" and also display 2 digit numbers
at time, as in 34 would show as 0:34 or even better would be as " 34
mins" in the cell and 3 to 4 digit numbers as time like "3:45" or "3h
45m" would be great.

Thanks guys, other than that, if you have any ideas to help me please
look at http://users.bigpond.net.au/adams_st...ng%20stats.xls and
let me know if i can get rid of decimal time in the data sheet..


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