"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..
As you've got the time merely as a number of minutes, divide it by (24*60)
and format as time. If you want the format as you've asked for, custom
format as:
h "hrs" mm "mins"
--
David Biddulph