Forum Discussion
Converting Time to a decimal format
Can anyone provide a method for converting a race time eg 0:09:05.0 into a decimal format that looks like 9.05 Unfortunately the template I am trying to auto-populate requires this rather odd format...
Hi,
Not sure i understood everything, but did you try to apply custom format "mm.ss" to the cell (use Ctrl+1)?