Results 1 to 2 of 2

Thread: Calculating lates (time)

  1. #1
    Seeker randz77's Avatar
    Join Date
    Oct 2015
    Location
    Philippines
    Posts
    11
    Articles
    0
    Excel Version
    2013

    Calculating lates (time)



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi. I'm trying to calculate if an employee is late or just in time. The shift starts at 12am and the employee logged in by 23:52. When I deduct it, it's giving me the value of 23:52 as LATE when in fact the employee logged in earlier than the shift start.. Not sure what to do. Thanks in advance.

    Sent from my INE-LX2 using Tapatalk

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,604
    Articles
    0
    Excel Version
    365
    cross posted without links:
    https://www.excelforum.com/excel-for...ates-time.html
    randz77, for your information, you should always provide links to your cross posts.
    This is a requirement, not just a request.
    If you have cross posted at other places, please add links to them too.
    Why? Have a read of http://www.excelguru.ca/content.php?184

Posting Permissions

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