Question about Microsoft Office Standard for PC

1 Answer

Creating vacation accrual spreadsheet

Im trying to create a spread sheet showing employees' accrued vacations as at December 31,2008. For each month an employee is entitled to 1.25 day and 15 days for a year.

Posted by on

Ad

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that has over 10 points.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 36 Answers

Here is one way to do it:
1. In column A enter the name
2. In column B enter their start date in the format day-month-2008 (31-12-2008 for Dec. 31, 2008); if a day is less than 10, put zero in front (03, 04, etc.)
3. In column C put 31-12-2008 (December 31, 2008, the last day of the year)
4. In column D, put C1-B1 and format as a number with 2 places after the period (10.25 for example) if you want to track partial days, other format for no zeroes after the period (13)
5. In column E, put this formula:
(D2/30)*1.25 (assuming this is line 2)
You can then copy these lines as many times as you need to, total them, etc.

Posted on Dec 30, 2008

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Master spredsheet shows REF# when opened remotely but not when opened on local machine


With out a copy of the master spread sheet and those linked to it, I could not give an answer, their are to many possable variables.

Jun 11, 2013 | Dell Computers & Internet

1 Answer

Create a program that will the salary, no of hours work, the deduction, total deduction and net pay.


The easiest way to do this is to use Excel spreadsheet.
This is what you need to do.
Create a label at the top of each column as detailed.
Add a employee to each row under Name of employee
Then against each employee add the data and the formula in the relevant cell under each column.

The first column - Name of the employee
2nd column - salary rate per hour
3rd column - hours worked
4th column - gross pay (formula = salary rate X hours worked)
5th column - tax deduction
6th column - other deductions
7th column - total deductions (formula = tax deduction + other deduction)
8th column - net pay (formula = gross pay - tax - total deductions)

At the last row you can include a total for Gross salary paid, total Tax collected etc.

Once you have setup this spread sheet make a copy of it and save it as a template.
You can then copy this template for each new financial year so you do not have to create a new one each year, you only need to make minor changes for new employees, rates of pay etc.

Another way to make a salary program is to use Access Database. You need more skills to do this, but it can provide greater reporting capabilities.

Mar 24, 2011 | Computers & Internet

1 Answer

I want an formula in excel to find out number of days present per month an perticular worker


Hello this is Baris,
Can you tell me more about this employee. Are you creating an excel spreadsheet to keep record of his days. Are you just getting the numbers from an outside source like a schedule.

To be able to give you an answer I will assume that you have the info already in the same spreadsheet.

Lets say Column A is the days of the month.
Column B is the information column like the hours that the employee worked. If the month has 31 days this is what you need to do.
Click on the cell B32 and type the formula
=count(B1:B31) and press enter. This will count the number off cells which have a value in it in that month.

If you provide me more info we may come up with a better solution. Hope this helps :)

Sep 24, 2009 | Microsoft Excel for PC

3 Answers

Gmail Auto Reply


Google HelpGmail HelpGeneral › Setting an automatic vacation response
Setting an automatic vacation response
Going on vacation? No access to the Internet? No problem! Use Gmail's vacation responder to let people know you won't be able to get back to them right away. You can set up a vacation response in your Gmail settings that will automatically reply to anyone who emails you. While the vacation responder is enabled, Gmail will send a response to anyone who contacts you.* If that person contacts you again after four days and your vacation responder is still enabled, Gmail will send another vacation response to remind the person that you're away from your email.
Here's how to let people know you can't respond right away:
  1. Sign in to Gmail.
  2. Click Settings along the top of any Gmail page.
  3. From the General tab, select Vacation responder on in the Vacation responder: section.
  4. Enter the subject and body of your message in the Subject: and Message: fields.
    • If you've enabled a personalized signature in your settings, Gmail will automatically append it to the bottom of your vacation response.
  5. Check the box next to Only send a response to people in my Contacts if you don't want everyone who emails you to know that you're away from your mail.
  6. Click Save Changes.
While the vacation responder is enabled, you'll see a banner across the top of any Gmail page, displaying the subject of your vacation response. To stop Gmail from automatically sending the response, click end now within the banner. Or, if you'd like to edit the response, click vacation settings.
  • Keep in mind that your vacation response will start over each time you edit it -- if someone receives your initial vacation response, and then emails you again after you've edited the subject or body of the message, he or she will receive the edited response, too.
* Messages classified as spam and messages addressed to a mailing list you subscribe to will not receive a vacation response.

*****http://mail.google.com/support/bin/answer.py?hl=en&answer=25922*****

Oct 22, 2008 | Google Gmail

1 Answer

Creating a holiday accrual spreadsheet.


Hi, I guess you mean vacation accrual. It's hard to help you here, without knowing the exact accrual formula. However here are some tips: Set up a column with the start date for each employee and use the today() function to get today's date. You can use the days360() funtion to calculate the number of days between two dates, assuming regular 30 days/month. For more date related functions, click on the Fx (letter f with an subscript x) to the left of the value/formula entry field at the top of the spreadsheet. Thsi gives you a wizard with a list of functions. Select the Data/Time group and you see all available functions and can interactively pull them together. Good luck K

Sep 05, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

1,491 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

3015 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18425 Answers

Alun Cox

Level 3 Expert

2678 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...