+ Reply to Thread
Results 1 to 6 of 6

Track tardiness

Hybrid View

  1. #1
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2504
    Posts
    19,129

    Re: Track tardiness

    I am going to respond here as this is the original thread and the file is posted here. (Please see Forum Rule #5 about thread duplication.)
    If I understand correctly then I suggest the following:
    1. Put actual date in row 3. This can be accomplished by putting 12/31/18 in cell BA3, 1/31/19 in cell BB3, selecting both cells and then dragging the fill handle to the right. Apply custom formatting mmm y.
    2. Remove the Employee Totals column from the end of each year and place it in either column A or B so that it will not scroll along with the rest of the spreadsheet.
    3. Populate the new Employee Totals column using: =SUMIFS(BB4:BZ4,BB$3:BZ$3,">="&EDATE(A$1,-12))
    Note that I assume the months for 2021 will be inserted between Dec 20 and the Emergency Days Used columns.
    Note that cell A1 is populated using: =EOMONTH(TODAY(),-1)
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  2. #2
    Registered User
    Join Date
    01-08-2020
    Location
    Greenville, NC
    MS-Off Ver
    Office 2016
    Posts
    4

    Re: Track tardiness

    Thank you so much JeteMc. I think I can get this to work!!! I'm so new to Excel and these formula's drive me crazy lol

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. IF formula to determine tardiness after 8:00 AM
    By chongmoo in forum Excel General
    Replies: 8
    Last Post: 02-13-2019, 12:16 PM
  2. [SOLVED] Undertime Vs Tardiness Vs Leaves and Present
    By yveth_13 in forum Excel General
    Replies: 5
    Last Post: 10-31-2018, 02:34 PM
  3. [SOLVED] compute for tardiness and undertime using different official time
    By nors in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-05-2018, 06:53 PM
  4. Replies: 19
    Last Post: 05-12-2016, 12:24 AM
  5. Designing a Tardiness report
    By Jsteelester in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-24-2014, 12:46 PM
  6. Round Robin Optimizer with Flexibility for tardiness
    By taninu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-07-2013, 01:29 AM
  7. Employee Tardiness Clock Time >5 Mins
    By edwyer247 in forum Excel General
    Replies: 1
    Last Post: 06-02-2012, 12:37 AM

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