excel training log question

I've been tracking my distance and time, but would like to see it converted
to pace. What is the formula I'd use for that? Say I did 2 miles in 18
minutes. So I have 2 in the first column, and 18 in the second column...
When I try to get something that looks like mm:ss in the 3rd column, it just
returns zeros.

I guess I know just enough to be dangerous...


.

Relevant Pages

  • Re: GPS Garmin Forerunner or Edge 305 for rowing?
    ... suggests that the forerunner only does pace and the edge only does ... My experience with the 201 suggests that they're of limited use in a boat - ... on a moving body of water the speed and distance are essentially irrelevant, ... display options: time, lap time, ave ...
    (rec.sport.rowing)
  • Re: Forerunner 201 advice
    ... I am thinking of buying a Garmin Forerunner 201 to monitor my pace / ... very twisty between the point it could last get an accurate reading and the ... Distance wise, I only really use it for a feel as to how much further I need ...
    (uk.rec.running)
  • FA: Garmin Forerunner 201 GPS Receiver, EXC, NR, L@@K!!!
    ... 201 offers athletes an easy-to-read display, ergonomic wristband, and integrated GPS sensor that provides precise speed, distance, and pace data. ... This unique feature allows you to set your training goal by configuring your Virtual Partner's pace and workout distance. ... Lap history—such as lap time, lap distance, and average pace—can be stored for up to two years. ...
    (rec.running)
  • FA: Garmin Forerunner 201 GPS Receiver, EXC, NR, L@@K!!!
    ... 201 offers athletes an easy-to-read display, ergonomic wristband, and integrated GPS sensor that provides precise speed, distance, and pace data. ... This unique feature allows you to set your training goal by configuring your Virtual Partner's pace and workout distance. ... Lap history—such as lap time, lap distance, and average pace—can be stored for up to two years. ...
    (rec.bicycles.marketplace)
  • FA: Garmin Forerunner 201 GPS Receiver, EXC, NR, L@@K!!!
    ... 201 offers athletes an easy-to-read display, ergonomic wristband, and integrated GPS sensor that provides precise speed, distance, and pace data. ... This unique feature allows you to set your training goal by configuring your Virtual Partner's pace and workout distance. ... Lap history—such as lap time, lap distance, and average pace—can be stored for up to two years. ...
    (rec.sport.triathlon)