Proper format for running pace calculation

ATHiker07 · Newbie Joined: 01 Mar 2011 Posts: 1 Location: Florida

I have been trying to create a formula which will allow me to average running pace for 2 daily runs. I also wish to create a weekly & monthly average, but I believe that will be easy once I have the format for the daily calculation correct. An example of the cells follows:

AM miles AM pace PM miles PM pace Daily miles Daily pace

I tried the following without success J2 =(C2*D2)+(F2*G2) / I2

Cell J keeps returning "1.82" as an answer, which obviously is not what I'm looking for as I need average pace in a MM:SS format. Any input would be much appreciated.

Villeroy · Posted: Tue Mar 01, 2011 9:36 am Post subject:

In your formulas convert all times to unit "Days". mph*24 = miles per day. The result will be a number of days rather than hours. Format this number as time.
All dates and times in all spreadsheets are based on unit "Days". Point zero on the time scale is 1899-Dec-30.
Number 40,603.75 formatted as date time is day #40603 and 3/4 of a day which is 2011-03-01 18:00
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org