Sponsor Message:
Non Aviation Forum
My Starred Topics | Profile | New Topic | Forum Index | Help | Search 
Excel Boffins: Help With Formulae?  
User currently offlineajd1992 From , joined Dec 1969, posts, RR:
Posted (4 years 5 months 6 days 11 hours ago) and read 2020 times:

Evening,

I want to set out a spreadsheet to keep track exercise mileage for bike riding, but I'm not sure how I'd go about it. My bike computer measures in metres, which isn't an issue. I've looked online for a formula that would allow me to convert that to miles/kms in separate columns (I know that'd be 2 different formulae) but it's got me stumped (I hate excel, I had to use it at school and I've forgotten everything I used to know unfortunately). I'd like the average MPH as well but that's not a major issue to work out by hand, I'd just rather let a computer do that  

I know how to set it out basically (it'll be sorted by "Week Starting" then I'll have my week total at the bottom of each week, that part is easy), but the convert one has got me stuck.

Thanks in advance, guys.

5 replies: All unread, jump to last
 
User currently offlinecasinterest From United States of America, joined Feb 2005, 4623 posts, RR: 2
Reply 1, posted (4 years 5 months 6 days 10 hours ago) and read 1970 times:

Something like this


A B C D E
Date Time (Hours) Time (minutes) Meters KM Miles MPH
7/6/2009 1 30 21000 21 13.04879504 8.699196691
7/12/2009 2 40 39000 39 24.2334765 9.087553686
1/12/2010 3 0 100,000 100 62.13711922 20.71237307



Convert Meters to Kilometers =+CONVERT($D5,"m","km")
Convert Meters to Miles =+CONVERT($D5,"m","mi")

MPH =CONVERT(D5,"m","mi")/($B5+$C5/60)


Much prettier in the actual spreadsheet.

IM me with your email , if you want the template.

[Edited 2010-04-15 12:48:15]


Older than I just was ,and younger than I will soo be.
User currently offlineStarAC17 From Canada, joined Aug 2003, 3375 posts, RR: 9
Reply 2, posted (4 years 5 months 6 days 6 hours ago) and read 1897 times:

Quoting ajd1992 (Thread starter):
I want to set out a spreadsheet to keep track exercise mileage for bike riding, but I'm not sure how I'd go about it. My bike computer measures in metres, which isn't an issue. I've looked online for a formula that would allow me to convert that to miles/kms in separate columns (I know that'd be 2 different formulae) but it's got me stumped (I hate excel, I had to use it at school and I've forgotten everything I used to know unfortunately). I'd like the average MPH as well but that's not a major issue to work out by hand, I'd just rather let a computer do that  

In case you don't know the conversion factors off the top of your head, these might make the formulas a bit easier because its just a simple multiplication/division of one cell to the factor you need.

These are the only one I think you will need

1 km = 1000 meters
1 km = 0.621 miles (approximately)
1 mile = 1610.3 meters (approximately)



Engineers Rule The World!!!!!
User currently offlineAaron747 From Japan, joined Aug 2003, 8152 posts, RR: 26
Reply 3, posted (4 years 5 months 6 days 6 hours ago) and read 1894 times:

Quoting ajd1992 (Thread starter):
I hate excel, I had to use it at school and I've forgotten everything I used to know unfortunately

You may hate it but really need to know it well. Just about any job worth anything makes use of it some time or another.



If you need someone to blame / throw a rock in the air / you'll hit someone guilty
User currently offlineajd1992 From , joined Dec 1969, posts, RR:
Reply 4, posted (4 years 5 months 6 days 4 hours ago) and read 1845 times:

Quoting StarAC17 (Reply 2):

In case you don't know the conversion factors off the top of your head, these might make the formulas a bit easier because its just a simple multiplication/division of one cell to the factor you need.

These are the only one I think you will need

1 km = 1000 meters
1 km = 0.621 miles (approximately)
1 mile = 1610.3 meters (approximately)

I know all the conversions, I was brought up using both, I just don't know the formulas. I haven't used excel in nearly 3 years to be fair.

Quoting Aaron747 (Reply 3):
You may hate it but really need to know it well. Just about any job worth anything makes use of it some time or another.

Yeah I know but I don't use it, so I've fallen out of practice.


User currently offlineJAGflyer From Canada, joined Aug 2004, 3527 posts, RR: 4
Reply 5, posted (4 years 5 months 6 days 4 hours ago) and read 1844 times:

If you're data is in cell C5 and its 5000 meters which you want to convert to KM in cell D5 it is as follows:

=(C5/1000)

The answer in D5 will be "5"

Drag the formula down by clicking and holding the black thing in the bottom of the first cell if you want to convert all the distances in the "C" column to meters.



Support the beer and soda can industry, recycle old airplanes!
Top Of Page
Forum Index

This topic is archived and can not be replied to any more.

Printer friendly format

Similar topics:More similar topics...
Help With Very Simple Italian Translation posted Sun Mar 21 2010 11:33:37 by JetsGo
Obama Says Louisiana Purchase Will Help With Earth posted Thu Mar 18 2010 06:03:55 by MadameConcorde
Help With Connecting SatNav To Internet Please posted Wed Feb 10 2010 02:50:41 by 747438
I Need Some Help With A Math Problem. posted Sun Jan 31 2010 11:16:23 by Alfa75
Needing Some Help With Hebrew! posted Thu Dec 10 2009 17:29:47 by Pawsleykat
Help With ITunes posted Sun Nov 29 2009 13:51:44 by Sunshine79
Help With Gmail posted Fri Nov 27 2009 08:46:24 by LHR380
Help With The Genre Of A Song posted Mon Sep 14 2009 14:31:59 by SXDFC
Computer Help With IE... posted Sun Sep 13 2009 18:40:44 by EMBQA
Help With A Riddle /Clue posted Sun Sep 13 2009 15:39:56 by LHR380
Help With Excel posted Fri Sep 7 2001 21:49:37 by SK A340
Help With Making Music. . . posted Fri Nov 18 2011 17:47:33 by wn700driver
Help With The Aincent Greek Font. posted Wed Nov 9 2011 09:57:46 by SXDFC
Help With A Lady posted Fri Sep 10 2010 14:14:28 by N776AU
Help With Apple Mail / Imap posted Sun Aug 22 2010 00:37:34 by Elite
Need Help With Marta (Atlanta) posted Fri Jul 16 2010 13:55:15 by Springbok747
Need Help With Directions In Brussels posted Thu Jun 17 2010 07:25:25 by AirTran737
Help With IPhone And BlackBerry IM Clients posted Tue Jun 1 2010 17:51:03 by Coal
Help With Question For A Final! posted Sun May 9 2010 15:18:52 by flanker
Help With A Homework Assignment posted Tue Apr 20 2010 18:21:50 by MIA