Time and Mileage incompatible

  • Thread starter Thread starter The Mighty Dad
  • Start date Start date
T

The Mighty Dad

Hi all. I have a spreadsheet that tracks driver movement as shown below.
Now the boss wants to add "average miles per hour". It's easy enough on
paper but the formatting messess it up on excel, any ideas? thanks.

Phil

Sample data (what the boss wants to do is use the tvl time to come to an avg
mph at the end of the day.

A B C D E
F G
1 DATE/LOCATION ARRIVE DEPART JOB TIME TVL TIME JOB ARR MILES
2 10/23/03 LOT 8:30 9:40 1:10 0:12 CHORES 91526
3 CONOCO 9:52 10:00 0:08 1:52 FUEL 91536
4 BRADY 11:52 12:21 0:29 0:48 PKUP 1 91652.2
5 BROWNWOOD 13:09 13:46 0:37 1:30 PKUP 1 91699.4
6 LOT 15:16 17:00 1:44 CHORES 91788.1
TOTAL 4:08 4:22 262.1
 
Phil,

Time is held as a fraction of 1 day, so if you divide a mileage by a time,
it effectively divides by that fraction, making it too big. In addition, it
formats he result as time.

What you should do is use

=mileage/time/24

and format the result cell as General. e.g.

=G1/E1/24

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top