Use MAXIFS with a calcuated parameter

I'm stuck because the HOUR function only takes in a serial number and not an array.

You might be surprised. If you insert +before the range (sometimes N(+range) and array enter you can coerce ranges into acceptable arrays).

Also if you are not aware of it the IFS family of functions requires building strings for comparison criteria. i.e. something like "<="&16

Play with it. If you are still stuck upload a representative sample Excel workbook with data consistent with what you describe.


To attach a file to your post: (Please no pics or screenshots ... saves retyping data.),

• be sure to desensitize the data
• click “Go Advanced” (next to Post Quick Reply – bottom right),
• scroll down until you see “Manage Attachments”, click that,
• click “Browse”.
• select your file(s)
• click “Upload”
• click “Close window”
• click “Submit Reply”

The file name will appear at the bottom of your reply.