Hey guys I have the following formula:
=IF(G2=“”,””,IF(NETWORKDAYS(B2,B2,$S$2:$S$22)>0,MIN(18/24,H2)-(MAX(6/24,G2),0))
B column = date
S2:S22 = holidays
H column = finish time
G column = start time
what the formula is meant to do is if the date is a Monday - Friday and not a public holiday...