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...
If you want to remove the surplus 24hrs with a formula then
= MOD(chiptime,1)
will do it. Otherwise change the number formatting to
hh:mm:ss
and the day will no longer show.