Formula to format cell color based on time ranges (not dates)

Hello, I'm hoping you can help me. I work for a non-profit organization and I'm trying to figure out a conditional formula based on an (old) Attendance RX report. I want to add work hour information...