Excel 2013 - Calculating elapsed time with formula

I am designing a spreadsheet to calculate elapsed time in a race, based on a particular pace per mile.
e.g. at a 12:00 pace, mile 1 would be 12:00, mile 2, 24:00, mile 3, 36:00 etc.

I thought I had established the proper time format for the column... as the setting I selected seems to support more than 24 hours (37:30:55).

Excel Time Format
However, when I do the math per a formula:
=<MILES >* 0:12:00
where MILES is the value in the row containing the mile# (1, 2, 3, etc.)
it stops working at Mile 3.

0:12:00 * 1 = 0:12:00
0:12:00 * 2 = 0:24:00
0:12:00 * 3 = 1:12:00 (s/b 0:36:00)

What am I doing wrong/missing?
Thanks,
Steve
LVL 4
Stephen KairysTechnical Writer - ConsultantAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

IrogSintaCommented:
Hmmm, I just tried it out and it works as it should with Mile 3 giving 0:36:00.  Are you positive that the row that supposedly contains Mile 3 doesn't really have 6 as its value?

Ron

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Stephen KairysTechnical Writer - ConsultantAuthor Commented:
OK I see what happened. Issue with copying a formula.

Excel Copy Forumula
Cell C2 contains the formula C1 (the pace per mile) * A2 (the mile marker in that row)
I wanted C3 to be C1 * A3 but it came out to be C2 * A3.  (12:00 * 2). In this case, by blind luck 24:00 was OK.
I wanted C4 to be C1 * A4 but it came out to be C3 * A4 (24:00 * 3) which is, of course 1:12:00.

So the question is now: how can I "trick" Excel into copying the formula C1 * A2 so that C1 is held constant?

Thanks...your remark about Mile 6 led me down this path! :)
IrogSintaCommented:
Use absolute notation.  If you wanted the row to remain as 1, you would use C$1.  If you wanted both the row and column to remain the same, you would use $C$1.

Ron
Stephen KairysTechnical Writer - ConsultantAuthor Commented:
Thank you! That works, now. Have a good evening!
Steve
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.