I have a timesheet that secretaries need automated. Basically, they need the first Start time for the date in Column B compared to the time in cell D9. If that time is 15, 30, 45 or an hour later than the time in D9, then it need to be counted in the table to the left of the data. It also need to be based on the month. For example, if John Doe was 15 minutes late 3 times in December, then in the table I would need the number 3 in J18.
I'm uploading the spreadsheet. Any ideas to help guide me or even the code to completely do what is requested would be greatly appreciated. Thanks.
Bookmarks