Calculating Average Speed in Excel

  • Thread starter Thread starter David Garrison
  • Start date Start date
D

David Garrison

Hi,

I am trying to calculate average speed in Excel to track
my progress in my bike riding. I'm having a problem
figuring out how to do this. any help would be
appreciated.

The relevant data is:
D16 (the miles ridden column) = 8.24
F16 (the time ridden hh:mm:ss format) = 0:29:18

The answer should be in the 17 mph area, but I can't get
the program to calculate it correctly.

Thanks in advance,
David
 
David Garrison said:
Hi,

I am trying to calculate average speed in Excel to track
my progress in my bike riding. I'm having a problem
figuring out how to do this. any help would be
appreciated.

The relevant data is:
D16 (the miles ridden column) = 8.24
F16 (the time ridden hh:mm:ss format) = 0:29:18

The answer should be in the 17 mph area, but I can't get
the program to calculate it correctly.

Thanks in advance,
David
Click to expand...

Times in Excel are stored as fractions of a day, so to get number of hours
you need to multiply by 24.
So, for a distance in A1 and time in A2, use
=A1/(A2*24)
Format the result cell as a number. (Excel may autoformat it as time).
With your data, I get approximately 16.87 mph.
 
I have an Excel spreadsheet in which I keep my yearly log. Column headings
are:

Mileage TimeH TimeM TimeS TimeInMin AvgSpd Where
24.2 1 29 0 89
16.3 Road

Basically I take the time and split it into separate columns of hours
(TimeH), minutes (TimeM), and seconds (TimeS). I then convert all of that to
minutes. Formula is:
=(Hours * 60) + Minutes + (Seconds / 60)

Average Speed then becomes:
=IF(TimeInMin = 0, 0, (Mileage / TimeInMin) * 60)

The IF statement prevents a division by zero error.

I have 365 rows and I just fill them in as the year progresses. I also
indicate if I was riding on the road or on rollers. I use a SumIf formula to
add those separately and have an average speed for the year for each.

HTH

Don
 
Anon said:
Times in Excel are stored as fractions of a day, so to get number of hours
you need to multiply by 24.
So, for a distance in A1 and time in A2, use
=A1/(A2*24)
Format the result cell as a number. (Excel may autoformat it as time).
With your data, I get approximately 16.87 mph.
Click to expand...

Running Internet Explorer 5.0 under OS 9.2.2 on a Power Mac beige G3 with
352 MB Built-in memory. Many web pages simply cannot be read because of
strange font and color combinations, e. g., apparent black print on a blue
background; orange on a red background; light yellow type on white
background.

Is this controlled by the choice of Web Content preferences ? I can
sometimes make pages readable by switching to preferences and reversing my
choices. If I've checked "allow page to specify fonts, " I uncheck it. If
I've chosen "Allow page to specify colors," I uncheck that. But my new
choices are not always successful and the pages stays absolutely
unviewable.

Anyone know the story here ? Do folks really create pages with green
printing on a chartreuse background, or is it my browser ? Is there a
"best preferences setting" that will work for a majority of pages ? Or is
it just willy-nilly, devil-take-the-hindmost and fugeddaboudit ? And, what
is "Color Sync(TM)" anyway: what does it purport to do; does it; and does
it affect page decipherability ?

Like Washington, I'm looking for a viable overall strategy Ñ but, is there
one ?

TIA, as usual.

-- Will --
 
Follow-up set to microsoft.public.mac.explorer

Since this doesn't appear to have anything to do with the previous
thread or with XL, I'm cross-posting it to the m.p.m.explorer group.
 
Back
Top