Forum Discussion
finding lowest race time
Hi all, i am trying to produce a semi auto race result programme. each team has 3 races so for example the times would be 01.23.25 - 01.23.65 - 00.59.36 so the last time is their quickest ti...
and yes, 3 different columns
If you have values such as 01.23.45 try replacing . with :
- ok, so using the colon works, but harder for typing etc... i tried formatting the cells to hh:mm:ss we use mm:ss:ms but thats not an option and shouldnt effect anything... my next question then is can i type my numbers some how without having to keep using the colon? so i just type 013232 and it would come up 01:32:32 as it just gives me 00:00:00
hope that makes sense, and thank you so farHere is an alternative:
It's possible, but it requires VBA code and disables the Undo feature,
- ah ok, i will put up with the colon for now.
thank you for your help