This content has been marked as final. Show 3 replies
I am working on a project where employees submit documents. When they do so, I receive a datetime that includes the day and time they submitted their work. I need to count the number of datetime entries in my data to establish the number of documents submitted. Furthermore, I need to count the number of unique days in which documents were submitted by employees (they must submit at least one document for it to count as a day worked).
As an example, if I had the following dataset for an employee:
10/10/2017 1:00 PM
10/10/2017 12:57 PM
10/09/2017 1:07 PM
10/06/2017 11:34 AM
10/04/2017 9:02 AM
Then I need to know that there are 5 records for this employee and 4 unique days worked.