Dividing 60 Minutes by hh:mm:ss

[The Animal]

Hi.
I am new to the forum.

I have a spreadheet that is used to calculate times to pick/pack line items in a warehouse situation. I have a cell (F142) (0:02:00) that calculates "minutes to pick per line item" (currently hh:mm:ss format).
I need a formula to calculate the projected "line items per hour" in F147 (currently Number format) I am using =60/F142 but gives me 42624.0 instead of 29.70.
Thanks hope someone can help
Stephen

 

[barry houdini]

Hello Stephen - if one item takes 2 minutes isn't that 30 per hour?

Try an extra division by 1440 (number of minutes in a day), i.e.

=60/F142/1440

format as number

 

[p45cal]

=60/1440/f142

 

[The Animal]

Thanks Guys Appreciate it