Not sure if I'd be on point with my description here but...
I need to extract the number of minutes when an employee was late/tardy. Then, have those lates minutes be "tallied and summed up" on a separate section.
> In the attached file, RAW tab is the actual appearance of the spreadsheet that is downloaded from our time management system. I highlighted the essential columns for this query.
> Note that only 23-Jan is shown in RAW.
> Late and Tardiness columns contain the same values.
> Undertime is also considered as Late/Tardiness thus, should be added.
> ATTENDANCE SPREADSHEET is the "desired presentation" of the report.
> SHIFTS Tab are the existing shifts for the Medical Department
Please see file attached for your perusal.
I'm having this dilemma because our time management system is not considering ≤15 minutes - from the scheduled start of shift - as late/tardy.
Bookmarks