hi everyone
The sample attached is a direct copy of a report I get from our Telecom team showing when an employee logs in to the phone system each day. Employees are to be logged in by 8:00AM, but we give a 5 minute grace period.
I am looking for a formula that will return "Late", if the FIRST log in time for the specific date is greater than 8:05:00 AM. Some days employees may log in/log out several times, thus the report shows each log in throughout the day.
For example, the first day on report (8/1/24) has two logins 7:56:27 AM & 2:08:01 PM. I only need the first time for the date to return "Late" if greater than 8:05:00 or leave cell blank.
One issue I've noted, if it matters, is that Column B is text. I put =Istext(b2) in C2, which shows true. I have tried multiple ways to convert to number, but have not had success. I'm not as well versed in all that.
As always, I appreciate your help!
Bookmarks