Results 1 to 2 of 2

Employee Tardiness Clock Time >5 Mins

Threaded View

  1. #1
    Registered User
    Join Date
    05-30-2012
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2010
    Posts
    1

    Employee Tardiness Clock Time >5 Mins

    Good evening one and all,

    This is my first post though I have been using this site as a resource now for some time. I am working on a tricky formula to show employees arriving later than 5 minutes to their scheduled time. Currently the formula shows as: =IF(AA50="","",IF(Q50>0,"ONTIME",IF($AA50>0,"LATE",IF($AA50<0,"EARLY",IF($AA50=0,"ONTIME"))))) I believe I should change $AA50>0,"LATE" to $AA50>0.92,"LATE" but keep getting a FALSE error. Am I overcomplicating things? Any help would be greatly appreciated!! E
    Last edited by edwyer247; 06-01-2012 at 09:49 PM. Reason: Rule #1 broken

Thread Information

Users Browsing this Thread

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

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