absence

Hello I'm hoping you can help if possible please. I have a spreadsheet with 3 tabs, on tab 1 is the formulas / calculations, tab 2 holds all the data and tab 3 has dates (start/end date). I am trying to calculate how many occasions of absence an employee has within a 6 month period and...

Hello, I have an absence tracker which records absence in a current 6-month rolling period and a previous 6-month rolling period. Each occasion of absence is recorded as a separate row and absence is manually added to the "current 6 month" sheet daily (as it occurs). A piece of VBA code then...

Hello, I use the below code for my absence tracker which was kindly provided on here. I now need to change it, so instead of looking at current 12 month rolling period and previous 12 month rolling period, it looks at: Current 6 months Tab - All absence in the last 6 month rolling period from...

Hello everybody, I am currently trying to determine from the data model, how high the absence rate for the individual weeks or months. So far, I've just added the factor to the pivot calendar, whether it's a workday. The table with the presence or absence of the employees is structured as...

Hi Guys. Hoping someone can help me with this, I can’t seem to figure it out. Table Absence: Employee ID Date Reason Table RTW: Employee ID Absence start date Absence end date RTW completed date (There is other data, not relevant) If looking to match the absence to the RTW. Each absence...

So i need to extract time from a 2 cells, clash against a date and return a sum so Column D = Name D2 = John Smith Column E = Shift Total Hours E2 = 08:00 Column F= Shift Date F2 = 06/01/2019 F3 = 07/01/2019 Column I = Name I2 = John Smith Column J = Absence Start J2=01/01/2019 08:00 Column K =...

Good morning everyone, I hope this is the place I can get some help with this....ill try to keep this problem short: I have a spreadsheet for absence. Our corporate trigger levels where an employee progresses to a stage of absence are 6 days in a row,4 weeks in a row, 3 months in a row and or...

Hi Everyone, this is my first post I have found some great solutions on this site over the last few months but I can find how to do what I am looking for and was hoping someone could help me I run a spread sheet to track absence days at work and need help with how to count specific absence...

Hi Hoping someone can help me :) I have a workbook that consists of two tabs. I have From a "calendar" that records employee absence through Sickness (S) or Industrial Sickness (I) We are finally going into the modern ages and will be recording this in a T&A system in the future. However, I...

Trying to count employee's consecutive days worked (no more than 13, 14th has to be a rest day). Problem is.. count should restart after an absence. 8/1 8/2 8/3 8/4 8/6 8/7 8/8 Consecutive Days Worked In In In In In In In 1 1 1 0 1 1 1 1 1 0 1 0 1 1 0 0 0 0 0 0 0 1...

I have tried for hours but cant figure it out. im hoping you can help. I have two spreadsheets. Spreadsheet 1 (SS1) that tells me a list of employee absence. column A has employee number and B has absence start date. The same employee may appear more than once if they have had more than one...

Needing assistance with creating my absence sheet. I am needing the dropdown/type cells and hours cells to calculate into other columns. Row A = Type with dropdown for types of absences vaca/sick/military Row B = # hours absence Row C = Sum of hours of certain type from dropdown...

Hi All, I am fairly new to VBA coding however a lot of people at my work rely on me to create useful macros for our office. One of the reports that we pull from our employee portal is absolutely atrocious and I have been tasked with formatting it correctly. So to give you an idea of the data...

Hi all First off just want to say what a great helpful community you have here. I hardly ever post questions mostly because I don't need to due to the help you have given out in the past but this time I am stumped on something. The kind of problem I'm about to describe is something I...

Hi, Having some problems trying to work out a formula to count incidents of absence. I have a report which gives me a list a column of names and next to it dates they have been absent. I want to work out the incidences of absence, e.g Johan - 01/01/2017, 02/01/2017, 03/01/2017, 10/02/2017 in...

Good Afternoon! I am hoping that someone out there may be able to help me with a hurdle I have reached. In a (large) nutshell, I am trying to design an absence spreadsheet to be used to calculate whether someone is entitled to receive sick pay. I have the spreadsheet calculating a person's...

Hi all, I'm trying to develop a absence tracker; I managed to cover most of the requirement apart from one that I need your help with. Workbook contains dates in row 12 and each individual absence is recorded in rows below as 1, 0.5 (day) etc. We are measuring absence on rolling 12 months basic...

I recently asked about counting "occurrences" and "half-occurrences" in an absence calendar. The premise is that row 1 contains a value indicating an absence (UP = unplanned, T = Tardy, LE - Leave Early) If the absence is .25 of an hour up to 2 hours, it's half an occurrence, if it's 2 hours or...

Good afternoon, I have a sample data set below.I have over 500,000 records. Each child can have from 1 to 182 days absent (1 to 182 lines of data). What I need to do is to have VBA list on Sheet2 every 10th school or 10th line per Id number and if the child does not have 10 absences then bring...

I have created an absence tracker that tracks points accured on a rolling 12 month system. If an employee takes an unexcused absence he gets a point. After 12 months, a point will be taken back. I believe I have completed this with this formula in I5...