MS excel - how do i work out average speed

Reply Subscribe

Thread Tools

Search this Thread

04 March 2003, 07:29 PM

LeeMac

Scooby Regular

Thread Starter

iTrader: (1)

Join Date: Aug 1999

Location: South West

Posts: 2,134

Likes: 2

Received 0 Likes on 0 Posts

probably dead simple but cant get my head in gear

eg. 500 miles - 4 hours = ????

Reply Like

04 March 2003, 07:32 PM

Rusty Festa

Scooby Regular

Join Date: Oct 2002

Posts: 1,998

Likes: 0

Received 0 Likes on 0 Posts

cell a1 = 500

cell a2 = 4

cell a3 =a1/a2

whatch me now have got this completely wrong

Reply Like

04 March 2003, 07:37 PM

LeeMac

Scooby Regular

Thread Starter

iTrader: (1)

Join Date: Aug 1999

Location: South West

Posts: 2,134

Likes: 2

Received 0 Likes on 0 Posts

doh! bit obvious, cheers

what about 25 miles in 35 mins

Reply Like

04 March 2003, 07:42 PM

Rusty Festa

Scooby Regular

Join Date: Oct 2002

Posts: 1,998

Likes: 0

Received 0 Likes on 0 Posts

you need to convert the minutes into hours

cell a1 = 35

cell a2 = 60

cell a3 = a1/a2

this will give you the 35 minutes as real number (where 0.5 = 30 minutes)

Reply Like

Reply Subscribe

Related Topics

Thread

Thread Starter

Forum

Replies

Last Post

+++BREAKING 07 HAWKEYE STI SPEC D, TEAM DYNAMICS, TEIN, S/S EXHAUTS, VF43, BREMBOS+++

Scott@ScoobySpares

Full Cars Breaking For Spares

05 August 2018 07:02 AM

BLOBEYE STI BREAKING (br coilovers/rota's/blizt nur/rcm gt headers/6speed/ej207/vf35)

Mattybr5@MB Developments

Full Cars Breaking For Spares

29 August 2017 07:18 PM

HAWKEYE SPEC C RA NBR EDITION (spec c ra extra/dccd 6 spd/ej207/twin scroll+many more

Mattybr5@MB Developments

Full Cars Breaking For Spares

17 July 2016 10:43 PM

HAWKEYE STI WR BLUE BREAKING(DCCD 6 SPD/PRODRIVE ALLOYS/VF43/BREMBOS ECT)

Mattybr5@MB Developments

Full Cars Breaking For Spares

22 October 2015 06:12 AM

Reply Share

First
Prev
1 / 1
Next
Last

Forum Jump