Dividing numbers format by time format

[Jader63]

Hi.
- My name is Jáder, from Portugal and this is my very first thread! my compliments to all of you Excel lovers.
- I wonder if there`s anyone who can help me. I`d like to know the formula to calculate how many strokes per minute I perform in my old ( very very old ) rowing machine. The example could be:

- In a total of 00:37 I`ve performed 487 full strokes; the average of strokes per minute is...?
- Tank you all so much. JÁDER

 

[Firefly2012]

Hi Jader

You need the time value in a decimal format - you can do thisby multiplying by 1440 (number of minutes in a day). So, assume you have your strokes in A1 and your time (00:37) in B1 then your strokes per minute is:

=A1/(B1*1440)

 

[Jader63]

Hi Jader

You need the time value in a decimal format - you can do thisby multiplying by 1440 (number of minutes in a day). So, assume you have your strokes in A1 and your time (00:37) in B1 then your strokes per minute is:

=A1/(B1*1440)

Firefly
- Please accept my best compliments. Thank you for your help, it was really precious.

 

[ehocontract]

try this ... put time in one column (t1) format as [h]:mm:ss, then in next column formated as numberical 2dp use formula = t1*24. You should get time in decimal formal, which you can use maths on.