Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I convert pace per mile to total time in minutes in excel?
i have pace per mile in minutes and total distance. I want to calculate
total minutes. What are the formulas I use? I'm currently showing pace per mile as "10:00" or 10 min per mile. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I convert pace per mile to total time in minutes in excel?
With pace per mile in cell A1 and the distance in B1 try the below formula
=A1*B1 and custom format the cell to [h]:mm -- Jacob (MVP - Excel) "sisteragent" wrote: i have pace per mile in minutes and total distance. I want to calculate total minutes. What are the formulas I use? I'm currently showing pace per mile as "10:00" or 10 min per mile. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I convert pace per mile to total time in minutes in excel?
Jacob's recommendation will work if you are actually entering 10:00 in your
cell. However, when you enter a time with only one colon, Excel assumes you are entering hours and minutes (which would be closer to my pace), not minutes and seconds. Again, if you continue to fake out Excel by using a format of [hh]:mm, then all will look good. But if you try to do anything more sophisticated with your data, you run the risk of getting hopelessly confused. I would recommend you enter your data as minutes and seconds, either as: 0:10 or 0:10:00 or 10:00.0 Then use Jacob's formula to calculate your total time, and display with a format of m:ss, or, if you're running for more than an hour, use h:mm:ss. Regards, Fred "Jacob Skaria" wrote in message ... With pace per mile in cell A1 and the distance in B1 try the below formula =A1*B1 and custom format the cell to [h]:mm -- Jacob (MVP - Excel) "sisteragent" wrote: i have pace per mile in minutes and total distance. I want to calculate total minutes. What are the formulas I use? I'm currently showing pace per mile as "10:00" or 10 min per mile. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I count mile times under 10:00 minutes only and get a perce | Excel Discussion (Misc queries) | |||
Does anyone know how to create a pace calculator (min/mile) in Exc | Excel Discussion (Misc queries) | |||
Average minutes per mile | Excel Worksheet Functions | |||
Convert total minutes to hours and minutes | Excel Discussion (Misc queries) | |||
Convert Total Hours and Minutes to Whole Number | Excel Worksheet Functions |