Results 1 to 3 of 3

Employee Tardiness based off start time

Threaded View

  1. #1
    Registered User
    Join Date
    12-27-2012
    Location
    Inland Empire, Ca
    MS-Off Ver
    Excel 2007
    Posts
    11

    Employee Tardiness based off start time

    Hello Excel Gurus,

    I cant seem to figure out how to track employee tardiness based off of the time they start. Basically I have employees who start at different times throughout the day in 15 minute intervals. They either start: on the hour,15 till,30 till, or 45 till. Now I need a formula that determines whether an employee is late based off their start time.

    For example if employee "X" starts at 8:00 AM and clocks in at 8:01 AM. They will be considered late. If they are late then the column titled tardy will display a "Yes" or "No."

    Thanks in advance,

    See Attachment for sample
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Employee Tardiness Clock Time >5 Mins
    By edwyer247 in forum Excel General
    Replies: 1
    Last Post: 06-02-2012, 12:37 AM
  2. Import of data based on start and end time
    By oskars in forum Excel General
    Replies: 1
    Last Post: 05-14-2012, 05:11 AM
  3. Replies: 3
    Last Post: 03-27-2012, 01:07 PM
  4. Calculating END time based on start time, breaks, and hours to complete
    By sweedey in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-01-2012, 11:29 AM
  5. Replies: 2
    Last Post: 05-20-2010, 04:19 AM

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