Forum Discussion
Time formatting in Excel
I'm trying to do a dashboard using an export of data from a 10km race. The Chip time is shown in minutes (elapsed) but when I click in the cell in Excel is shows a completely different format / formu...
PeterBartholomew1 , but that doesn't work for the elapsed time.
I rather assumed elapsed time would work correctly with either the datetime or the time, provided the race is not run at midnight. Something that might require more careful handling is any gun/chip calibration errors that could be positive or negative. I am also puzzled by a timing system that times to the nearest minute; I am more used to 1/100ths of a second.