Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Partial success achieved but clearly I am not understanding something here.

Doing some research and experimenting, I have discovered that if I display the time value as a 4 digit decimal number and multiplying by 24, I can achieve a calculation that gives the expected value for pace/speed. However that is only true when the time is in the form hh:mm:ss. If I have a time that is mm:ss, it is being interpreted as hh:mm and the calculation is still incorrect.

Any help would be appreciated. In the meantime, I will continue to experiment.