Multiplying Time Values

[Derek]

I am a runner and wish to track my projected running pace
over a variety of distances. To do this, I need to
multiply minutes and seconds to calculate the elapsed time.

For instance, if I run 1 mile in 7 minutes, 10 seconds
(7:10), it will take 35:50 to run 5 miles. (i.e. 7:10 * 5
= 35:50).

Is there a formula in Excel that will allow this
calculation to work?

Any assistance you can provide is appreciated.
Thank you!

 

[Bob Phillips]

Derek,

Yes, but it's really tricky (sorry couldn't avoid that - it's easy really).

If A1 holds the time, then it is as simple as =A1*5

Just make sure that both cells are formatted as hh:mm:ss, and enter the time
as 0:7:10, otherwise it will think it is 7 hours 10 minutes.

Get it right and you'll be doing 6:10 miles <VBG>

--

HTH

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

 

[Jason Morin]

A1: 7:10
B1: A1*5

Custom format B1 as [h]:mm.

HTH
Jason
Atlanta, GA

 

[Peo Sjoblom]

Format the cell as mm:ss, you might have to enter it as 0:7:10
then multiply time*mileage and format result as mm:ss

 

[Bob Phillips]

A1: 7:10
B1: A1*5

Custom format B1 as [h]:mm.

Jason,

I know there are runners who run for more than 24 hours, but as an ex-runner
myself, anything over 2 hours is too long (IMO).

Bob

 

[Norman Harker]

Hi Derek!

I know you have good answers but here's a general reference on
handling time that might assist:

Chip Pearson:
http://www.cpearson.com/excel/datetime.htm

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.