finding lowest race time

[Andybeten]

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 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??

[#2]

@Andybeten 

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.

[#3]

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

[#4]

and yes, 3 different columns

[#5]

@Andybeten 

If you have values such as 01.23.45 try replacing . with :

[#6]

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

[#7]

@Andybeten 

It's possible, but it requires VBA code and disables the Undo feature,

See Date and Time Entry 

[#8]

@Andybeten 

Here is an alternative:

[#9]

ah ok, i will put up with the colon for now.
thank you for your help