Automating a time sheet

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.

I have quite a few views, but no suggestions. Anything anyone can offer would be greatly appreciated.

Well that could explain why I'm not getting any suggestions. haha Let me make the adjustments you pointed out and I'll update the workbook appropriately. Thanks for at least letting me know that it doesn't make any sense. :-)

Okay. That was the wrong workbook. Here is the correct one. Thanks again for pointing it out for me Jaslake.

Okay. I've highlighted the rows that were used. I hope that you are able to see them. I wasn't sure what kind of color-blindness you have, but I can change the colors if needed. Basically the reason these rows are counted and not the others is due to the dates. If you look at each date, there are two entries. The reason for that, the staff have to enter their start time and then their start time after lunch. The second entry is the lunch entry. The Office Managers are only interested in the first start time for the date. For example, for 11/12/2012 they are only interested in the first entry which is 8:30. The second entry is when John Doe returned from lunch at 2:00.

Basically, if there are multiple entries for the date, we only need the first entry. Then I need the time from the first entry compared to the start time in D9. If the time is 15, 30, 45 or 60+ minutes past the start time, then it needs to be counted in the correct cell in the table to the right.

Actually your manual count is correct. So, based on that one rule, the true counts would be November = 5, December = 18, and January = 8. I apologize for that confusion.

They have to put their time into an application that rounds up to the nearest 15. So, they are allowed the first 15 minutes as free. After that, they are considered late. Unfortunately, that application doesn't have any reporting capabilities and the firm doesn't have in-house developers of any kind. So, when they extract the data this is the result that's in the spreadsheet.

But, there aren't any other rules. Thanks for helping on this.

Sorry it has taken so long to get back to you. I am finally back down to Earth. Yes, that is exactly what I need it to do. It counted them perfectly and placed them in the correct cells in the table.

Sorry it took so long to get back. We've been working on this project and your code helped get us over the hump! Thanks a bunch! It also helped with a few other items that has us stymied! You guys ROCK!