Cutter, pretty much any of these formulas would work, except I also need the OR statement to include the Extended Hours. The original spreadsheet has 100K+ records and many of them have extended hours (I:I="Yes") but do not fall into the three given categories in F:F, hence the OR statement.