+ Reply to Thread
Results 1 to 2 of 2

Schedule Adherance on Split shift

  1. #1
    Registered User
    Join Date
    03-12-2021
    Location
    South Africa
    MS-Off Ver
    2019
    Posts
    1

    Red face Schedule Adherance on Split shift

    Hi guys

    I have agents who work split shifts. They work for 4 hours, then off for 4 and then work another 4 hours. I have attached a sheet which I would like to show a few things:

    1. What time they logged in.
    2. If they were late and by how long.
    3. If there is multiple login and outs in the shift due to outage etc, how much time was lost within that given shift.

    I have tried numerous ways but nothing is working and I really hope somebody can help me with this?

    Thank you Kindly :-)
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    02-24-2016
    Location
    The Netherlands
    MS-Off Ver
    365
    Posts
    92

    Re: Schedule Adherance on Split shift

    Hi,

    For the Late Column on the home tab you can use this formula:
    Please Login or Register  to view this content.
    To fill the timelost column you ca add an uptime column on the Data tab with the formula
    Please Login or Register  to view this content.
    The for the time lost column on the home tab
    for cell F2
    Please Login or Register  to view this content.
    for cell F3
    Please Login or Register  to view this content.
    You can copy those formulas dowm by two.

    Hoop this works for you

    Wouter
    Attached Files Attached Files
    WouterM
    The Netherlands

+ 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. [SOLVED] Day and Shift wise allocation from Roster / employee shift schedule
    By Ravi_Kadu in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 01-11-2021, 07:40 PM
  2. Replies: 3
    Last Post: 09-09-2019, 10:25 AM
  3. Replies: 4
    Last Post: 12-20-2018, 12:11 AM
  4. Job Shift Schedule
    By LostGuy80 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-19-2016, 08:11 AM
  5. Replies: 0
    Last Post: 10-27-2014, 11:54 PM
  6. Shift Schedule - 3 Shift Coverage - Auto Populate Roll-up Summary Schedule
    By chips1256 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-31-2012, 09:32 AM
  7. Shift Schedule
    By lisauk74 in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 08-27-2009, 05:02 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