ExcelBanter - Items per hour

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Items per hour (https://www.excelbanter.com/excel-discussion-misc-queries/133291-items-per-hour.html)

k1ngy

Items per hour

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

Gary''s Student

Items per hour

=60*A1/B1

In algebra

(10lines/10minutes) * (60minutes/1hr) === answer in lines/hr
--
Gary''s Student
gsnu200709

"k1ngy" wrote:

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

David Biddulph[_2_]

Items per hour

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)
--
David Biddulph

"k1ngy" wrote in message
...
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

All times are GMT +1. The time now is 11:07 PM.