Trying to find the longest time

[SandraStace]

I am currently trying to calculate the biggest time in a column for a specific month. Something like the following...

[TABLE="width: 500"]
<tbody>[TR]
[TD]Month[/TD]
[TD]Offered[/TD]
[TD]Done[/TD]
[TD]Rc[/TD]
[TD]ave[/TD]
[TD]longest[/TD]
[TD]task[/TD]
[/TR]
[TR]
[TD]Sep[/TD]
[TD]1234[/TD]
[TD]7525[/TD]
[TD]125[/TD]
[TD]45.57%[/TD]
[TD]0:15:45[/TD]
[TD]0:01:78[/TD]
[/TR]
[TR]
[TD]Oct[/TD]
[TD]5481[/TD]
[TD]5165[/TD]
[TD]154[/TD]
[TD]75.89%[/TD]
[TD]0:45:15[/TD]
[TD]0:05:98[/TD]
[/TR]
[TR]
[TD]Nov[/TD]
[TD]1548[/TD]
[TD]1568[/TD]
[TD]525[/TD]
[TD]98.99%[/TD]
[TD]1:15:15[/TD]
[TD]0:25:87[/TD]
[/TR]
</tbody>[/TABLE]

Trying to fill column F with the max figure for the specified month from a daily table that is filled out like this
[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Month[/TD]
[TD]wk day[/TD]
[TD]offered[/TD]
[TD]done[/TD]
[TD]rc[/TD]
[TD]ave[/TD]
[TD]longest[/TD]
[TD]task[/TD]
[/TR]
[TR]
[TD]11/24/2018[/TD]
[TD]Nov[/TD]
[TD]Sat[/TD]
[TD]545[/TD]
[TD]85[/TD]
[TD]71[/TD]
[TD]87.25%[/TD]
[TD]1:15:15[/TD]
[TD]0:04:78[/TD]
[/TR]
[TR]
[TD]11/25/2018[/TD]
[TD]Nov[/TD]
[TD]Mon[/TD]
[TD]4848[/TD]
[TD]151[/TD]
[TD]24[/TD]
[TD]35.87%[/TD]
[TD]0:20:15[/TD]
[TD]0:00:50[/TD]
[/TR]
[TR]
[TD]11/26/2018[/TD]
[TD]Nov[/TD]
[TD]Tue[/TD]
[TD]444[/TD]
[TD]151[/TD]
[TD]48[/TD]
[TD]98.78%[/TD]
[TD]0:04:58[/TD]
[TD]0:00:15[/TD]
[/TR]
</tbody>[/TABLE]


Wanting to get the longest time for the month from the daily data. A formula is preferred.

Thank you for any help you can provide!

 

[James006]

Hello,

You can use following Array Formula:

=MAX(IF(B2:B10="Nov",H2:H10))

Instead of the usual Enter key ....Use simultaneously the three keys Control Shift Enter

Hope this will help

 

[SandraStace]

Thank you! Such an easy formula, and it was exactly what I needed.

 

[James006]

You are welcome ...