Return Highest value if Range of cells dont contain "Sat" or "Sun"

[TheEnergyMan]

[TABLE="width: 331"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Occupancy[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Occupancy Start[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Occupancy End[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Occupancy Start Weekend[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Occupancy End Weekend[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]DHW[/TD]
[TD]DHW[/TD]
[/TR]
[TR]
[TD]DHW Start Monday[/TD]
[TD]05:00[/TD]
[/TR]
[TR]
[TD]DHW Start Tues - Fri[/TD]
[TD]05:30[/TD]
[/TR]
[TR]
[TD]DHW Stop Mon - Thurs[/TD]
[TD]15:00[/TD]
[/TR]
[TR]
[TD]DHW Stop Fri[/TD]
[TD]15:00[/TD]
[/TR]
[TR]
[TD]DHW Start Sat[/TD]
[TD]09:00[/TD]
[/TR]
[TR]
[TD]DHW Stop Sat[/TD]
[TD]13:00[/TD]
[/TR]
[TR]
[TD]DHW Start Sun[/TD]
[TD]00:00[/TD]
[/TR]
[TR]
[TD]DHW Stop Sun[/TD]
[TD]00:00[/TD]
[/TR]
[TR]
[TD]Cylinder Temps (°C)[/TD]
[TD]61.0°C
[/TD]
[/TR]
</tbody>[/TABLE]

So, see the above in excel, 2 columns 16 rows

I am trying to use the function in Cell B3 :
{=MAX(IF(AND(B7:B609 <> 0, $A$7:$A$609 <> ISNUMBER(SEARCH("Sat",$A$7:$A$609)), $A$7:$A$609 <> ISNUMBER(SEARCH("Sun", $A7:$A609))), B7:B609)) }

To find the max value (latest time) in the range that is < 1 (so that the Temp value isn't included) and only use the cells that do not contain Sat or Sun

the formula returns 0 ??

when i Use the formula : =MAX(IF(B7:B610 < 1,B7:B610))

It works Fine but i dont want the Sat and Sunday values in there only the weekly values

thanks in advance for any help

 

[Special-K99]

There is no row A.

Rows go horizontal, coloumns are vertical (like the columns of a building).

Why are you checking column A if it just contains descriptions?