Hi there,
I'm needing a little help please - i'm completely stuck trying!
I have rows and rows of the following:
Employee TimesheetDate EnteredDate
Jim Smith 30/04/2015 01/05/2015
Dave Jones 20/05/2015 03/06/2015
Pam Brown 02/02/2015 04/04/2015
And I need to know what percentage of the entries were entered by the Sunday of each week. The TimesheetDate column relates to the day a job took place and the EnteredDate relates to the day in which the person recorded the entry. Basically, i'm needing to know who is entering their jobs on time and by being able to see (for example) that 50% of staff enter their jobs in the last week of the month etc.
At the moment it's a manual process i'm undertaking by wading through data and it's taking me forever.
Any help/suggestions would be greatly appreciated!!
I'm needing a little help please - i'm completely stuck trying!
I have rows and rows of the following:
Employee TimesheetDate EnteredDate
Jim Smith 30/04/2015 01/05/2015
Dave Jones 20/05/2015 03/06/2015
Pam Brown 02/02/2015 04/04/2015
And I need to know what percentage of the entries were entered by the Sunday of each week. The TimesheetDate column relates to the day a job took place and the EnteredDate relates to the day in which the person recorded the entry. Basically, i'm needing to know who is entering their jobs on time and by being able to see (for example) that 50% of staff enter their jobs in the last week of the month etc.
At the moment it's a manual process i'm undertaking by wading through data and it's taking me forever.
Any help/suggestions would be greatly appreciated!!
