n00b!e EXCEL HELP to create LATE Attendance Sheet

Hi All, Please help me create a simple excel sheet that considers the amount of late minutes for an employee on a particular date as 1
Example:

I if an employee was late on a Tuesday for 7 minutes, and on a Wednesday for 8 minutes, so I want it to show me in the total that he was late 2 times during this month for example, not actually take the total mins as that is only for my records

Also, my manager has given me this excel sheet for a few days, can you please help me do the same sheet but for the entire month?

Thanks a lot


Here is a link to the Excel Sheet

 

Instead of "Sum", you need to select "Count Numbers" from the drop-down menu -

Just copy/paste as much days as you need.

 

Thanks a lot!!! You rock~

 

You're welcome