Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Display minutes ONLY and calc difference | Excel Discussion (Misc queries) | |||
Average time for a race in minutes seconds & tenths | Excel Worksheet Functions | |||
adding rows of hours and minutes to get a total | Excel Worksheet Functions | |||
Formatting minutes and seconds to calculate a total average | Excel Worksheet Functions | |||
calculate average hours and minutes | Excel Worksheet Functions |