Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display a number as Kilometers and k/hr & as Time
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 |