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,927
    Location:
    Serbia
    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,927
    Location:
    Serbia
    You're welcome ;)
     
Loading...
Thread Status:
Not open for further replies.
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.