Forum Discussion
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...
10/25/2024 8:29:00 AM
8:29:00-8:15:00=00:14:00
14 minutes
rather than 35 minutes?
In this example, with the employee start time at 8:30, she is early so there wouldn't be any penalty points accrued. If she punched in at 8:45, she would have 4 points accrued.
I'm reviewing the point structure with my supervisor but it may be:
0 to 3 minutes grace time.
4 minutes to 8 minutes = 1 point.
9 minutes to 12 minutes = 2 points.
13 minutes to 15 minutes = 3 points.
Over 16 minutes = 4 points.
Employee start and end times vary so I would enter these in separate columns on the first line of each employee.
Thanks.