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...
Are the three values in three different columns?
For Excel to recognize the values as time values, they should use : instead of .
For example: 01:23:25
Excel treats 01.23.25 as a text value.
- 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 far
- i have tried formatting the cells to different formats, when i set it to time it would keep resetting what i had to 00:00:00
