calculate elapsed time given mph and distance

Guest · Oct 28, 2003

Can anyone please tell me how in Excel to calculate elapsed time given mph and distance?

J.E. McGimpsey · Oct 28, 2003

Time = Distance/Rate

A1: 60 (MPH)
A2: 420 (miles)

A3: =A2/A1 ==> 7 (hours)

Dan E · Oct 28, 2003

CC,

miles ÷ miles/hour = hours

Dan E