Hello,
I have a data set bunch of work dates for a list of employees in 2018, with a breakdown of what's billable and what's non-billable days.
I also have travel reports to indicate date ranges that they were in London.
Is it possible to figure out of those days they were in London, how many of those days they worked (from data set 1) were billable vs non-billable? I imagine I would need to somehow look up the employee ID's.
I have a data set bunch of work dates for a list of employees in 2018, with a breakdown of what's billable and what's non-billable days.
I also have travel reports to indicate date ranges that they were in London.
Is it possible to figure out of those days they were in London, how many of those days they worked (from data set 1) were billable vs non-billable? I imagine I would need to somehow look up the employee ID's.