Formula Using Hours and Minutes

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

How can a formula be constructed using time (in hours).

For example: car travels 470 miles in 9hrs26mins. How many
miles does it do in 2hours28mins?
 
Dave,

A1 holds mileage, A2 holds time,

In B1, put
=A1/(A2*24)
and format as General. This gives the MPH

In B2, put
=B1*TIME(2,28,0)*24
or
=B1*A3*24
if the time of 2:28 is stored in A3, again format as general

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Put 470 in A1, in B1 put 09:26 and in C1 put 02:28

to get how far you get/got after 02:28 use this formula

=C1*1440*A1/(B1*1440)

format result as general returns 122.897526501767 miles so approx 123 miles
 
Back
Top