+ Reply to Thread
Results 1 to 2 of 2

Need help in calculating Net Lates

  1. #1
    Registered User
    Join Date
    05-30-2013
    Location
    Karachi, Pakistan
    MS-Off Ver
    Excel 2007
    Posts
    1

    Need help in calculating Net Lates

    Hi, we are a small business firm with 15 employees working for us. We use excel to maintain monthly employee attendance and employ a policy of late coming and goings. Now we require a function that will record a 1 after every 5 Net late (Incoming less Outgoing). Meaning if the total of Late arrival is greater then the total of late leaving and that tally reaches five or above that then a 1 appears or 2 appears in case the number reaches 10 and so on. Excel verison is 2007

    Thank you in Advance,

    Muneeb Hanif

  2. #2
    Forum Contributor WinteE's Avatar
    Join Date
    04-07-2007
    Location
    Netherlands
    Posts
    544

    Re: Need help in calculating Net Lates

    Add a new (hidden) column where you subtract the Arrival from the Going time, and after that subtract the normal working hours. Now you can use =COUNTIF() to calculate the differences < 0 .
    Just keep it simple !


    http://www.excelguide.eu
    In English as well as in Dutch

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1