pto

Hello, I am hoping to get help with a formula that can calculate PTO accrued by a specific date. For example, If I wanted to know how much PTO Jane will accrue by 11/16/2019, what is that amount based on how many hours Jane receives in a year. Our current formula (below) doesn't work for...

hello all i have a few formulas running and the breakdown is below. I have a page which is called PTO Hour Settings" which the sheet "Employees" references. A manager is to input what information applies to his account in the PTO hour setting page so this formula needs to be universal. The...

Hi, We use Excel for our timesheet. The formulas work well, except for the PTO (Paid Time Off). We can't get it to add to total hours without adding to regular. Here are the forumulas: Total Hours: =ROUND(IF((OR(B16="",C16="")),0,IF((C16<...

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...

hope someone can help. So i have an excel timesheet output. Some spots in the excel it will show like this 6 Hrs Straight / 2 Hrs PTO or just pto like this 5 Hrs PTO or maybe no pto. So basically i want to add up pto value in the entire sheet the value wherever it is "x Hrs PTO" thank you...

i would like the named range to show only the rows that are displayed in "PTO Used" column, but show all columns associated with the rows. And then dynamically update/change as PTO used is entered. so if 5 rows of PTO Used are entered display 5 rows and ALL columns. If 10 rows of PTO Used are...

I have seen templates that calculate pto time and keep a running balance. However, I have not seen one with our company scenerio. We zero out pto time at the end of every fiscal yr and begin the new yr with a zero balance. Our employees earn pto time based on the hours they work every 2 wks. We...

Hey guys! Im new here and am getting really frustrated trying to make my formula work. I need to accrue vacation time for my full time employees. At hire date anniversary, they get 40hrs and accrue 3.33hrs per pay period. I need to figure out the formula for my balance column at the end, AF6...

I am calculating employees PTO hours each pay period, a starting balance, earned hours and requested time off. Some employees will request up to 14 days off within the pay period but the total subtracted needs to be limited to 80 hours. My formula works in calculating a running PTO balance...

CSV File: Columns = last, first, EE name, paycode (several paycodes for each emp, ex John Smith will have a paycode for PTO, a paycode for jury duty, a paycode for OT, etc etc), Hours My current process: Isolate every single pay code than do a vlookup into a new file Ex: filter by PTO, copy and...

Hello, I have an excel workbook with two worksheets. - Worksheet "A" is simply a full calendar for the year, showing each month and day. - Worksheet "B" is our PTO schedule for 5 different employees, with columns showing the following data, starting on column B: PTO Dates <tbody> From To...

I need a formula that will convert overtime into comp time. Our timesheets are by the minute and are not rounded. Any help is greatly appreciated!

Thanks for the time in reading this. This is my first post. I am trying to figure out (without any success yet) on how to use excel to figure out my employes PTO. Personal Time Off. This is how it works. Employees must work for three months before getting 5 hrs of PTO. Each month after...

What a great resource...glad I found this community. I am creating a time off calculator for company I work for. We use a pretty standard PTO methodology that gives employees 2 days annually as "Personal Days" on the anniversary date with additional PTO being accrued on a weekly basis...