Time and Mileage incompatible

[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

 

[Bob Phillips]

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)

 

[The Mighty Dad]

AWESOME. Worked like a champ. I appreciate the help. Thanks

Phil