LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Average minutes per mile

I'm a runner, and want to keep track of/work with my times. I want Excel to
tell me what my average time is per mile. So let's say cell b2 is the number
of miles (example, 4.0 miles) and cell c2 is my total time (37 minutes, 41
seconds). I want to know how many minutes per mile I've done. This is
probably really easy -- but Excel thinks I'm entering an actual clock time
(12:37:41 a.m.) vs. just a quantity of minutes/seconds. Can someone help me?
Thanks.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Display minutes ONLY and calc difference tjsmags Excel Discussion (Misc queries) 8 August 29th 06 08:03 PM
Average time for a race in minutes seconds & tenths Gammalite Excel Worksheet Functions 1 March 28th 06 03:50 AM
adding rows of hours and minutes to get a total Tipps Excel Worksheet Functions 1 November 4th 05 07:03 PM
Formatting minutes and seconds to calculate a total average VeronicaO Excel Worksheet Functions 4 October 6th 05 08:42 PM
calculate average hours and minutes llstephens Excel Worksheet Functions 4 November 30th 04 03:47 PM


All times are GMT +1. The time now is 11:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"