Calculating Average Pace for a running log

Question

Level 1

15 points

Calculating Average Pace for a running log

I've been using Appleworks spreadsheets for my running logs for years, and am attempting to switch over to Numbers, but have run into a wall. On Appleworks, when I wanted to calculate average pace for a run , I would very simply do the following:

MILES A1= 7
DuratioN B1= 1:10:00
Average pace C1= =SUM(B1/A1)

B1 and C1 would be formatted with the choice 13:59:01 under Number formatting.
Very simple.

With IWORKNumbers, I'm getting the following error message in C1:

"the operator "/" expects a number, but cell C1 contains a date"

I have C1 set to 14:10:30 on Inspector, with Date set to NONE.

It's hard to fathom that an Appleworks spreadsheet could be superior to a Numbers one in any way, but I guess with this simple function, it is.

Any help would be greatly appreciated.

Thanks.
-MB

Macbook Pro, Mac OS X (10.6.5)

Posted on Dec 27, 2010 6:08 PM

Reply

Answer 1

Dec 27, 2010 6:28 PM in response to Musebean

MB,

You are almost there, just one version short in Numbers evolution. You could format columns B and C as Duration. The problem is that Numbers 08 didn't support Duration, as Numbers 09 does.

You can convert the Time value to Minutes, divide, and convert it back to Time.

Jerry

Reply

Answer 2

Musebean Author

Level 1

15 points

Dec 27, 2010 7:13 PM in response to Jerrold Green1

Thanks for your reply, Jerry. I bought '08 back in '08, and now that I've moved up to a MB Pro, I'm finally getting around to exploring it for running logs. Unfortunaley, '08 is a bit lacking in its design--feel a bit bamboozled. If I want duration it's going to cost me for an update.

Until I do that, I'm going to try a work around as suggested. I found this formula in one of your posts:

=3600 C2/(SECOND(D2)+MINUTE(D2)60 + HOUR(D2)*3600)

It gives a result in MPH. I just need to figure out how to convert the MPH into a 14:10:30 format.

Thanks again for your time and energy.

Reply

Answer 3

Musebean Author

Level 1

15 points

Dec 27, 2010 7:30 PM in response to Musebean

I got it. Just take the MPH and plug it into a time function based on seconds:

=TIME(,,3600/H20)

Thanks, again.

Reply

Answer 4

Musebean Author

Level 1

15 points

Dec 27, 2010 7:44 PM in response to Musebean

I combined the formulas to simplify:

h14=#miles
h15=duration (eg 1:00:00)
=TIME(,,3600/(3600 H14/(SECOND(H15)+MINUTE(H15)60 + HOUR(H15)*3600)))

Reply

Answer 5

Dec 28, 2010 4:22 PM in response to Musebean

MB,

It's probably not a good time to be updating your iWork if you can wait a week or two. We've been anticipating a new iWork release for about a year and the rumors are really heating up now.

You have figured out the time conversion I was hinting at and should be on your way.

Regards,

Jerry

Reply