This content has been marked as final. Show 3 replies
I have some timestamp data of employee entry/exit times and I'm trying to highlight times in a straight chart that the employee arrives late, stays late or leaves early but am having some difficulty in making a 'time' comparison work.
I have the entry time via a timestamp format down to hh:mm:ss (07:30:00) and compare it to a MakeTime(9,0,0) in the Visual cues and no matter what the entry time is it is always highlighted.
Sample Data attached.