[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

Author Message
ATHiker07
Newbie

Joined: 01 Mar 2011
Posts: 1
Location: Florida

 Posted: Tue Mar 01, 2011 8:45 am    Post subject: Proper format for running pace calculation 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
Super User

Joined: 04 Oct 2004
Posts: 10065
Location: Germany

 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
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 8 Hours Page 1 of 1

 Jump to: Select a forum OpenOffice.org Forums----------------Setup and TroubleshootingOpenOffice.org WriterOpenOffice.org CalcOpenOffice.org ImpressOpenOffice.org DrawOpenOffice.org MathOpenOffice.org BaseOpenOffice.org Macros and APIOpenOffice.org Code Snippets Community Forums----------------General DiscussionSite Feedback
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum