Items per hour

K

k1ngy

Ok ever so slightly confused
10 lines in 10 mins = 60 lines an hour how do i calculate this
a1 is lines b1 is mins
Please help
 
G

Gary''s Student

=60*A1/B1

In algebra

(10lines/10minutes) * (60minutes/1hr) ===> answer in lines/hr
 
D

David Biddulph

If B1 is just a number, in minutes, then you want
=60*A1/B1

If B1 is a time in Excel time format, then
=A1/(B1*24)
 
Top