Units per minute?

Hello everybody,

a quick question:

How do I create a formula that returns a unit per time number? I have a row that contains a time i.e. 0:37 (0 hours and 37 minutes), and another row shows how many samples are run through in that period i.e. 382, so i would like a fomula that gives 382 samples divided by 37 minutes. How is that possible?

And another task is, that I have different instruments analysing the samples which I would like to dissect into the different instruments.

I have attached a file with the above examples, and hoping for some good help.

Thanks in advance.

In E3 try:

=C3/B3/1440

copied down

You may have to format as Number.

In F4 try something like:

=IFERROR(INDEX($E$3:$E$25,SMALL(IF($D$3:$D$25=1,ROW($B$3:$B$25)-ROW($B$3)+1),ROWS($G$4:$G4))),"")

confirmed with CTRL+SHIFT+ENTER, not just ENTER and copy down. Same for G4 replacing the 1 with a 2.

Note: The range after the INDEX is the range you are trying to pull from for your list. You can adjust to suit what you want. Remember to re-confirm with CSE keys before copying down and/or across.