Remember Me?

#1
June 7th 05, 07:23 PM
 Forrest Posts: n/a
How do I calculate running pace?

I have time entered in the form: hh:mm:ss and distance in kilometres. I am
trying to calculate my pace in the form: minutes per kilometre. Problem is
that Excel interprets any digits entered as time to be "time of day" as
opposed to a cumulative time. Therefore, when I try to calculate
time/distance, I get a blank cell (no error message).

#2
June 7th 05, 09:11 PM
 JE McGimpsey Posts: n/a

XL makes no distinction between time of day and elapsed time - they're
both stored as fractional days, regardless of display format, so

03:00:00 = 03:00:00 AM = 0.125

To get minutes per kilometer, with say, 8 km in 20 minutes:

A1: 0:20:00
A2: 8
A3: =A1/A2

format A3 with

Format/Cells/Number/Custom m:s/k\m

In article ,
"Forrest" wrote:

I have time entered in the form: hh:mm:ss and distance in kilometres. I am
trying to calculate my pace in the form: minutes per kilometre. Problem is
that Excel interprets any digits entered as time to be "time of day" as
opposed to a cumulative time. Therefore, when I try to calculate
time/distance, I get a blank cell (no error message).

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Joseph Excel Discussion (Misc queries) 2 May 31st 05 11:31 AM fniguy24095 Excel Discussion (Misc queries) 1 May 4th 05 08:12 PM Kim Excel Discussion (Misc queries) 2 March 15th 05 08:04 PM cs02000 Excel Worksheet Functions 0 March 6th 05 10:11 PM abs2299 Excel Discussion (Misc queries) 8 March 3rd 05 02:21 AM

All times are GMT +1. The time now is 03:48 PM.