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

seanquinn wrote:

would I need to enter the In and Out column information?

Did you read the notes and referenced material on the _Info worksheet?  ("Similarly, there should be an indicator for each clock-in/clock-out time for each such action.")  If you do not create something like an In/Out indicator as needed (whether manually or by cell formulas in a helper column), how do you expect the CF formulas to determine which entries are punching in for the day, and which are punching out for the day?  (And consider the "special cases" where an employee skips lunch for a day, or takes an additional off-clock break to care for a child, etc.)

seanquinn wrote:

I'd like to enter the in / out time on the first cell of each employee's list

Putting two data values (the standard clock-in time and the standard clock-out time) into one cell is bad design.  That would require more complicated CF formulas, as I noted.

I'll not respond to the other questions until I am sure you have read that _Info worksheet content.