Condense rows based on alphabetic value, Display Max & Min values in other columns

Originally Posted by Marcol

Does this workbook do what you need?

Nope. Looks like that pulls earliest start and latest end time for the whole week. I need it for each day.

Fancy formulas though.

I'm trying to give the staff a schedule that is easier to read. Rather than breaking down each of their tasks, they just need to know what time they need to be in the building.