finding lowest race time

Question

Hi all,&nbsp;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&nbsp;so the last time is their quickest time so i want this to automatically go into the next column... i have been trying to use the "min" function but this just puts a 0 there??

hansvogelaar · Answer

Andybeten&nbsp;
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.

andybeten · Answer

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

andybeten · Answer

and yes, 3 different columns

hansvogelaar · Answer

Andybeten&nbsp;
If you have values such as 01.23.45 try replacing . with :

andybeten · Answer

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:00hope that makes sense, and thank you so far

Forum Discussion

finding lowest race time

8 Replies

Resources