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