n00b!e EXCEL HELP to create LATE Attendance Sheet

Discussion in 'other software & services' started by berryracer, Apr 25, 2012.

Thread Status:
Not open for further replies.
  1. berryracer

    berryracer Suspended Member

    Joined:
    Jan 24, 2008
    Posts:
    1,640
    Location:
    Dubai, UAE
    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
     

    Attached Files:

  2. Seer

    Seer Registered Member

    Joined:
    Feb 12, 2007
    Posts:
    1,596
    Location:
    Singidunum
    Instead of "Sum", you need to select "Count Numbers" from the drop-down menu -

    ex1.png

    Just copy/paste as much days as you need.
     
  3. berryracer

    berryracer Suspended Member

    Joined:
    Jan 24, 2008
    Posts:
    1,640
    Location:
    Dubai, UAE
    Thanks a lot!!! You rock~
     
  4. Seer

    Seer Registered Member

    Joined:
    Feb 12, 2007
    Posts:
    1,596
    Location:
    Singidunum
    You're welcome ;)
     
Loading...
Thread Status:
Not open for further replies.