Question about Microsoft Office Standard for PC

1 Answer

Creating a holiday accrual spreadsheet.

Hi I need some help with setting up an accrual spreasheet to keep track of staff holidays, can someone help me with the formula? i need the formula to calculate the holiday from the start date of the employee to the current date. Any Ideas? Many Thanks

Posted by on

Ad

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 9 Answers

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

Posted on Sep 06, 2007

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,
A 6ya expert can help you resolve that 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.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
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

New bright greatland holiday express train


Check the connection from the transformer to the track, and that all the track is well connected. Make sure nothing is touching both tracks, shorting them out.

Nov 25, 2013 | New Bright 384 Holiday Express Animated...

1 Answer

Hi having trouble with our new bright musical holiday station electric animated train set...very frustrating as one of the train tracks broke off a little part so no matter what my husband tries to do the...


Yes, additional track is available from several places, such as Hobbylinc.com, and TowerHobbies.com. At this time, just after Christmas, they are out of stock, however. Walthers.com has them in stock (1-4-2011). You can find extra track on sale on eBay, as well. Be sure to get the track with the brass covers, as New Bright sells battery powered trains that use bare plastic track, which will not work with the 384. A Google search will turn up more sources.

Dec 12, 2010 | New Bright 384 Holiday Express Animated...

3 Answers

Pls help to write an excel formula to display date, thanks! Cell A1 input a date - 1 Sep 10, Cell B1 write a formula to calculate & display the date which = (A1 + 14 days but if the result is a...


This is too complicated for a help site like this, you are going to want to consult an excel forum, or some excel professional in your area. This is far beyond the scope of what you can expect for $15, which I'm sure you now realize after 10 days of trying.

Thanks
Tim

Sep 26, 2010 | Microsoft Excel for PC

2 Answers

Instructions for the New bright 384 holiday express


Not sure what instructions you need, but the setup is very simple.
1. Put your track together
2. Attach the track power connector by slipping it under the track and pushing, then lift up the other side. This will make the two metal contacts connect to the track.
3. Plug the connector from the power pack into the track module (It should only go one way)
4. Plug the control box (looks like a telephone cord) into the track module, Will only go one way
5. Place the locomotive on the track.
6. Place the Treetop Tender on the track (you need both to make it run)
7. Connect the large connector from the treetop tender to the loco
8. Turn on the command module and press forward ...

You should now be running in circles ...

Hope this helps...

Dec 15, 2009 | New Bright 384 Holiday Express Animated...

2 Answers

The train is not responding to the remote.


I had a similar problem with my 11000 Holiday Tradition Express. I cleaned the track with an eraser (pencil-type) and then used a soft cloth to clean any possible residue. After doing this twice, my train is now running.

Dec 04, 2009 | Lionel 11000 Holiday Tradition Express...

1 Answer

Where can I buy a track clip for my New Bright


http://www.newbright.com/

New Bright does not offer any replacement or repair parts for thier products.

They have a 60 day replacement warranty, but after that, you are on your own.

Nov 28, 2009 | New Bright 384 Holiday Express Animated...

5 Answers

No power to track and/or train. Power to Holiday Express Train


Check the power circuit that goes to the track if there is an open circuit, open circuit means, break or cut line that can not flow the current going to the track to give a power to the train, ok.

Nov 27, 2009 | New Bright 384 Holiday Express Animated...

1 Answer

An electricalroblem with Holiday Express train


This train set is very particular and getting it to work each Christmas is a family tradition in frustration. First you must make sure that all the pieces of track are connected properly and that the track is perfectly symmetrical and flat. We double-check the battery positions every year and find one in wrong. There are + and - signs, but they're hard to see; use a flashlight. There is a black toggle switch below and behind the red stack that toggles forward (to make the train go forward) and backwards (reverse); straight out perpendicular to the train is the "stop" position. Also, you have to start at a stop/switch station. One other note: behind the red stack, there is a smaller black stack. If you turn this, you can make smoke come out of the stack. I think I remember someone suggesting a drop of cooking oil. Hope this helps!!! Hope you get it set up for Christmas!!!

Mar 31, 2009 | New Bright 181 Toy Christmas Train

1 Answer

Creating vacation accrual spreadsheet


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.

Dec 27, 2008 | Microsoft Office Standard for PC

1 Answer

Creating a formula


go to the field with the number of day formula and modify the formula just add to it this *8. The result will be in hrs.
Assuming a holiday uses 8 hrs of pay. It sounds like everyone starts with 25 holiday X 8 hrs or 200 total hours,

Jun 18, 2008 | Computers & Internet

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

614 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2995 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18424 Answers

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

Answer questions

Manuals & User Guides

Loading...