I'm attempting to create a spreadsheet to log my jog distances, and times.
I'm wanting to be able to type in the time in a standard format (i.e. 17:38 =
17 minutes and 38 seconds), and be able to take that value from the cell
17:38 and display a pace in minutes/mile of the same format (minutes:seconds
/ mile) by dividing the displayed time 17:38 by the distance.
Example:
A2= 17:38 (min:sec)
A3=2 (miles)
A4 = A2/A3 (displayed as min:sec/mile)
I've attempted to use many of the built in time functions, but they seem to
all be based on an absolute time, and not an elapsed time. If anybody has
any ideas, I would greatly appreciate them! Thanks, and keep on pluggin' and
chuggin' those numbers!

Mike