vacation

I have been tasked with developing a spreadsheet to track employee vacation accrual. Employees begin accruing andare able to use vacation days once they have been with the company 90 days from their start date. After the calendar year of your hire date has been completed, your vacation...

Hello, I'm hoping some one can get me started building this excel spreadsheet... I have only a tiny bit of excel experience I think this spreadsheet should be real simple and only have a few calculations... I'm thinking the only Data needed will be: Current Date. Current Vacation hours...

Hello. I'm trying to create a time sheet that tallies overtime hours after 40 hours worked, with sick time, vacation and holidays, where none of these can put one into overtime. if anyone can help me with this formula, or knows of an existing template, it would be greatly appreciated! Thank you.

Hi, I like many other do not pay OT until a person actually works 40 hours. So if a person works 10 hours on Monday (2 hours of OT) but takes 2 hours of sick time on Tuesday. I want my spreadsheet to Net the sick time on Tuesday against the two hours extra time worked on Monday. I think...

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

Hi everybody, A new method of paying out vacation time was just implemented at my job, and since I'm the manager I need to execute it. Here's what I'm hoping those of you that excel at Excel can help me with... I have a spreadsheet with each employees vacation hours earned for the year...

I know this is Mr. Excel and not Mr. Outlook but this forum has been very helpful to me in the past and I do not know where else to go for this kind of issue. I am the team leader of my shift and I use a shared outlook calender to keep track of vacation and attendance. It is shared to everyone...

Hoping someone will be able to help me out with this accrual issue I'm having. I have looked at other threads and tried to make them work for what I need but keep getting errors. The issue I'm having is trying to calculate the accrual for vacation in hours for each pay cycle and having issues...

Hello! I'm new to the website, but have found many great answer here also. I am hoping someone might be able to provide me with some insight. I have been creating an excel spreadsheet for a client to track used sick and vacation days. At the end of the year, they carry over any unused sick...

How to create a formula that will copy a cell from a closed workbook to a cell in opened workbook.

Please I want some assistance with certain formulas. J2 Used Vacation Days. E2 Unused Vacation from Two Years Ago F2 Unused Vacation from Last Year H2 Remaining Vacation Days (this year) I have Starting date of Employee in C2 Date till today in D2 The Used Vacation...

OK, I want to created this worksheet with the Vacation Accural Formula from scratch. Basically, I need to create a spreadsheet showing number of accumulated vacation days for an employee based on the number of days they accrue per day per year. We created a formula that basically used the...

Hello, I have been trying to figure this out for days it is time to move on to a new chapter in my life. Could someone please see if they have any advice? <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I am trying to figure out how to accrue...