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?
Thank you for reviewing my question.
My goal is to have Excel "judge" how late after the employee's start time he/she punched in. In the example, she punched in one minute early at 8:29. Other times she punched in late. Moreover, she punched out early at 1:00 rather than at 1:30, the time her shift ends. I hope this makes sense.
