News2 mins ago
Excel Formula
4 Answers
I would like to enter details of my running in a spreadsheet. So, I would like to be able to enter time in one column and distance in another column & then by using a formula get a result in a third column which will say my average of how many minutes it has taken me to run each mile on that day.
Also is there a formula to convert miles to kilometres and visa versa. Any help will be gratefully recieved.
Also is there a formula to convert miles to kilometres and visa versa. Any help will be gratefully recieved.
Answers
1 to 4 of 4
Best Answer
No best answer has yet been selected by tenrec. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.
Time is stored as a fraction of a day i.e. 1 = 24 hours, so to convert a time field to minutes multiply the cell contents by 24 * 60 = 1440
thus if A1 contains the time (in time format) and B1 contains the distance in miles then the number of minutes per mile is: (A1 * 1440) / B1
Remember when you enter that into a cell to precede it with an equals sign '=' to make it a function rather than just text. If you subsequently click on that cell to select it then you can click and drag the little square at the bottom right of the selected cell down the column to set the appropriate function in all those cells too.
thus if A1 contains the time (in time format) and B1 contains the distance in miles then the number of minutes per mile is: (A1 * 1440) / B1
Remember when you enter that into a cell to precede it with an equals sign '=' to make it a function rather than just text. If you subsequently click on that cell to select it then you can click and drag the little square at the bottom right of the selected cell down the column to set the appropriate function in all those cells too.
1 to 4 of 4
