Results 1 to 2 of 2

Thread: Units per minute?

  1. #1

    Units per minute?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.
    Attached Files Attached Files

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,429
    Articles
    0
    Excel Version
    Excel 2016
    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.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •