employee

I am trying to calculate PTO for my company of 600+ employees. I have used a few of the formulas posted here over the years, but can't seem to get it work per our policy Example: If an employee has a hire date of 6/3/18, from 12/16/18 through today would equal 6 pay periods at the <1 year rate...

Good Evening, I have a sheet called Employee List which holds information on every employee and what tests they require. However, when employees need booking in for tests it takes a fair bit of sorting, is very time consuming and messy which leads to data input errors. I was wondering if...

Ive been lurking on these boards since I started working and a former boss of mine steered me to the site. you don't know it but many of you have been incredibly helpful over the last 6+ years, so thank you. boss of mine decided to start a new monthly excel challenge and while I have one way of...

I have downloaded an Employee attendance record Excel Sheet that keep tracks of days of such as sick day , vacation etc and it seems pretty good. Located here: https://templates.office.com/en-us/Employee-attendance-tracker-TM02780235 But currently it goes from January 1st to End of December is...

<colgroup><col><col><col span="3"><col><col span="5"><col span="21"><col></colgroup><tbody> Employee Code Employee Name 1-Jan 2-Jan 3-Jan 4-Jan 5-Jan 6-Jan 7-Jan 8-Jan 9-Jan 10-Jan 11-Jan 12-Jan 13-Jan 14-Jan 15-Jan 16-Jan 17-Jan 18-Jan 19-Jan 20-Jan 21-Jan 22-Jan 23-Jan 24-Jan 25-Jan 26-Jan...

Hello, I need some assistance. I am trying to calculate how many people are present in a given time interval (15 minutes). I have listed the person, start time, end time, lunch start time, lunch end time, Breaks (2) start & end times all separate. On a separate sheet I have a set of times 5am -...

I have a download from by HR system but I'm having problems getting the data into a format for the report I have to generate. I want a report that looks like the following... <tbody> Employee Name Medical Dental Vision Vision Pay Flex Emp1 MedBasicFamily DenBasicFam Vision $18.00...

Hi All - any help with this issue would be greatly appreciated. I have a sheet where I make work assignments (including budgeted hours) to each employee by task by day. There can be multiple assignments and employees on any given day. The sheet outlines all assignments for a year and looks...

So, I have a list of employee names that I'm matching a plan type (there are multiple plans per employee) and having it return a value. My issue is that the value from the sheet that the information is on will sometimes have a space at the end of the employee name. I've been trying to use a...

I don't know what is causing these but I am doing a merge with Power Query and losing rows when I click on expand. For simplicity sake I have two tables, one has Employee Number and Name and the other has Employee Number and Salary. Not all employees have a salary on the second table so I did...

Hi, Can someone please help me with this? Every month I have a raw data report with these columns: Employee, Leave type (vacation, statutory holyday, other paid leave), number of hours, week, day,month. Instead of doing a pivot table, I would like to organize the information with formulas...

I need one formula that will display information based on three different variables. Does the below make sense? If cell A1 equals = True If cell A2 equals = Hello Cell A3 will Display = Employee A If cell A1 equals = True If cell A2 equals = HI Cell A3 will Display = Employee B If cell A1 is...

I am have simple IF OR statement I am trying to do, but it's not working. I have 2 columns of vlookups I did as two checks against employee numbers. So the vlookup is either returning their employee # or an #NA . I am now trying to do an =if(or(e2>0,f2>0),True,False) formula. Basically...

I'm building an overview spreadsheet that takes information from multiple different reports. The formula I'm struggling with identifies employees by last name while all the other reports use full name (Last, First, MI), so I need to use partial text or wildcards. The report provides a row for...

Hi all, Long time user, 1st time poster :) I have about 700 lines of salary to move into three separate columns (C3, C4, C5) on the right, some of the employee numbers are in the column A more than once, depending on the different rates of pay they get and to do this manually is painful. There...

hello, the company i work for maintains an employee list in an SQL database that i have imported into excel as a table. i have i used the rank function so that each employee can be referenced alphabetically by team. i have also created a drop down that lists the team name, and another drop...

I feel like I have myself running around in circles. I need a macro that will create a variable range based on the number of rows that contain specific information. The start and end of each range is variable. The columns are not variable. For example: Employee 123 has 6 rows of data so the...

Hi there. I am attempting to create a loop using SUMPRODUCT to find a date within a date range for an employee number and returning a value. This is my situation. I have an overtime workbook that list the dates (Column B) and hours of overtime worked (Column E) by employee number (Column A)...

Hello. I'm trying to use Index/Match to pull corresponding data by extracting a string from a cell, but it is not working. My extraction formula is working correctly. Formulas are below each cell. I do not want to create a new column (I do not want to eliminate the additional formula in the...

Hi all, I have a list of of employees with a unique number assigned to each one. Then i have a separate list with the entire list of employees and their 1Up manager as well as their 2 Up manager. I need a script that will look up that employee on the list, finds their 1 UP manager, checks...