Running pace calculation
fripouille54
Posted messages
5
Status
Member
-
noisycity66 Posted messages 1 Status Member -
noisycity66 Posted messages 1 Status Member -
Hello,
I want to integrate a pace calculation into a training log
A= distance in km
B= time hh:mm:ss
C= pace min/km
I applied the following formula
C=(B*60*24)/A
the problem is the result is given in decimal minutes rather than minutes and seconds
for example
A= 6.10 B=00:39:17
Excel result C=6.44 (6.44 minutes) but the actual pace is 6.27 min/km (6 minutes and 27 seconds)
what adjustment should I make?
Configuration: Windows 8 / Firefox 28.0
I want to integrate a pace calculation into a training log
A= distance in km
B= time hh:mm:ss
C= pace min/km
I applied the following formula
C=(B*60*24)/A
the problem is the result is given in decimal minutes rather than minutes and seconds
for example
A= 6.10 B=00:39:17
Excel result C=6.44 (6.44 minutes) but the actual pace is 6.27 min/km (6 minutes and 27 seconds)
what adjustment should I make?
Configuration: Windows 8 / Firefox 28.0
2 answers
-
Good evening
You can proceed as follows to convert and display in min and sec
in A1 the distance in B1 the time and in C1 the formula:
=INT((B1*60*24)/A1) " ' " & ROUND(((B1*60*24)/A1 - INT((B1*60*24)/A1))*60,0) & " '' "
Set cell C1 to Standard format
Best regards
--
"Imagination is more important than knowledge." A. Einstein -
Hello
When I do B1 / A1, the result is 00:06:26 and the cell is in time format
Otherwise, you can try this:
=((HOUR(B1)*1/24)+(MINUTE(B1)*1/24/60)+SECOND(B1)*1/24/60/60)/A1 the result is also 00:06:26
--
Practice makes perfect. - It’s when you’re up against the wall that you see the bricklayer - you always learn from your mistakes.
