Question about Microsoft Excel for PC

3 Answers

Excel I am trying to create the following for my company and am stumped: Start Date * Rate of Starts per week(WORKDAY) = Finish Date I would like to change the rate of starts to give the finish date. Please help

Posted by on

Ad

3 Answers

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Governor:

    An expert whose answer got voted for 20 times.

    Scholar:

    An expert who has written 20 answers of more than 400 characters.

  • Expert
  • 146 Answers

Like previous poster, I'm guessing that you want something like this......Whate we need to know is : what formats do you need for Dates and Rate ?

Start Date Rate per Workday Finish Date

Posted on Jan 08, 2008

Ad

  1. GFK'
  2. GSDFG,'SDF
  3. GDS',G

Posted on Jan 05, 2008

Ad
  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Sergeant:

    An expert that has over 500 points.

  • Expert
  • 272 Answers

Your issue is not stated very clearly so I'll make some guesses about your problem.
I'm guessing you mean "rate" (Starts-per-Week) is the number of starts you have that week.
I'll guess that those starts are not new start dates but something else-maybe job starts.
Each start implies a job duration period. Do you want to know the finish date of each job or are you only interested in when the last job will be completed? Don't think I can give you meaningful Excel formulas at this time.
Maybe Excel is the best tool for this job but I suspect someting like Microsoft Project would be more appropriate (but expensive). You should Google "project tracking", "project orgainization" and "Gant chart" and read what you find to get a good feel for your problem and how to solve it.

Posted on Dec 29, 2007

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

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

How many days from 01/11/1944 to 01/07/2016


Date difference from Jan 11, 1944 to Jan 7, 2016 The total number of days between Tuesday, January 11th, 1944 and Thursday, January 7th, 2016 is 26,294 days.
This is equal to 71 years, 11 months, and 27 days.
This does not include the end date, so it's accurate if you're measuring your age in days, or the total days between the start and end date. But if you want the duration of an event that includes both the starting date and the ending date, then it would actually be 26,295 days.
If you're counting workdays or weekends, there are 18,782 weekdays and 7,512 weekend days.
If you include the end date of Jan 7, 2016 which is a Thursday, then there would be 18,783 weekdays and 7,512 weekend days including both the starting Tuesday and the ending Thursday.
26,294 days is equal to 3,756 weeks and 2 days.
The total time span from 1944-01-11 to 2016-01-07 is 631,056 hours.
This is equivalent to 37,863,360 minutes.
You can also convert 26,294 days to 2,271,801,600 seconds.


Number of days between January 11th 1944 and January 7th 2016

Jan 10, 2017 | Watches

Tip

How to use System Restore


You can access System Restore through <b>Help and Support</b> or through your <b>All Programs folder</b>. <br /><b>Through Help and Support:</b><br />Click <b>Start</b>, and then click <b>Help and Support</b>.<br />Under <b>Pick a Task</b>, click <b>Undo changes to your computer with System Restore.</b><br />Follow the instructions on the wizard.<br /><b>Through the All Programs menu:</b><br />Click Start. Select <b>All Programs</b>. Select <b>Accessories</b>. Select <b>System Tools</b>. <br />Click <b>System Restore</b>. <br />Follow the instructions on the wizard<br /><b>How to Create a Restore Point:</b><br />Open System Restore. <br />Select <b>Create a restore point</b>, and then click <b>Next</b>.<br />In the <b>Restore point description</b> box, type a name for your restore point. System Restore automatically adds the date and time that this Restore Point is created.<br />To finish creating this restore point, click <b>Create</b>.<br />

on Jul 11, 2011 | Computers & Internet

1 Answer

Workday function in excel formulas


The WorkDay Function returns a number that's the serial date that is the indicated number of working days from a given date (the starting date). Working days EXCLUDE weekends and any dates identified as holidays. Use WORKDAY to exclude weekends or holidays when you calculate invoice due dates, expected delivery times, or the number of days of work performed.
The Syntax is:
=WORKDAY(start_date,days,holidays)
where:
- start_date is in Date format (and can be a calculated value);
- days is a number of elapsed days after start_date (can be calculated, can be negative to indicate a date BEFORE start_date);
- holidays is an array of holidays you can specify if desired.

May 01, 2014 | Microsoft Excel for PC

1 Answer

I can't set the time on the Timex 1440


To set the time on your Timex 1440 Watch, please follow these directions:

1. Press and hold MODE (Upper left button)
(HOURS will flash and you'll be in Alarm Mode).

2. Press MODE again to enter TIME mode.
(SECONDS digits will flash.)

3. Press ADJUST (bottom right button) to set SECONDS to zero.

4. Press START/STOP (upper right button) to select MINUTES

5. Press ADJUST to change

6. Repeat to set Hours, Date, Month, and Day of the week.
(Go through 12 hours to set AM or PM)

7. Press MODE when finished

8. To display DATE from TIME display, press START/STOP

9. With DATE displayed, press and hold START/STOP, then press ADJUST to change display between DATE-MONTH

10. With TIME displayed, press and hold ADJUST, then press MODE to switch between 12 and 24 hour format.
I hope you are now able to set the time on your watch! If you appreciate these instructions, please remember to rate this post.

--Sandy

Apr 18, 2011 | Timex Watches

1 Answer

I have 10 not 9 i i install the program and now my computer wont do anything the screen is black i tired the f8 but that didnt work either


As soon as your computer boots press and hold F8 Key to start it in Safe Mode or in Last Known Good Configuration.
I recommend you to start in a Safe Mode. Assuming you are running windows 7, click on "Start" Menu and type "System Restore".
Follow the screen and choose a date before you started installing your new software. After finishing wizard it will reboot and should work normally. However you need to reinstall the software because it might not be there after restore.

WARNING:- You might loose all the new data or files you created on or after that date, therefore before starting "System Restore" get the backup of all date you have created on and after the date.

Jun 27, 2010 | Avanquest Fix-It Utilities 9 Professional...

1 Answer

Reminder in excel


There are a couple of types of spreadsheet - Depending on the size of the data you are working with - filter may the quickest option or Query report.

Your worksheet will contain all your data i.e. Customer, contact no, outstaning actions and due date - You can create a filter aon this set criteria on the due data - as less than or equal to todays date - which will only display your outstanding actions required by today or earlier.

Another option if you have installed MS Query, is to create a seperate report - again using the criteria of due date being less than or equal to today.

Producing this from your existing data is much easier than trying to re-create your data - But I can send you how I would create this sheet if the above explanation is not easy to follow - If you let me have your email address.

May 31, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

REQUIRE EXCEL TIMESHEET Thursday to Wednesday. With DAY, date, start and end times with 1, 30 MIN meal break, total hours for the day (not to exceed 7), any time over 7 THEN GOES TO TIME IN LEIU COLLU


Here are already prepared template time sheets of which your description fits several.

http://office.microsoft.com/en-gb/templates/CT101172771033.aspx?av=ZXL000

May 30, 2009 | Microsoft Excel for PC

1 Answer

FORMULA NEEDED FAST


Yes you can create the formula outside the cell or you can create it one time and copy it down to the other cells. That way it will populate once it is used.

The formula should be Base Rate * .05 to get the result then add the result back to the base rate.

Dec 18, 2008 | Microsoft Excel for PC

3 Answers

Need excel solution


Hello ycool11, If your asking what i think you are the formula would be
=(a2-a1)*24
That assumes a2 is that last date entered and a1 is the initial starting date. if you would like a more intense formula let me know and i'm sure i can help.

Oct 22, 2008 | Microsoft Excel for PC

1 Answer

CAN'T CALCULATE DATES TO GIVE DEADLINE


cell 1 (date format) = start date
cell 2 (number format) = number of days = cell 3 - cell 1
cell 3 (date format) = deadline = cell 1 + cell 2

Oct 16, 2008 | Microsoft Excel for PC

Not finding what you are looking for?

Open Questions:

See all Microsoft Excel for PC Questions

Microsoft Excel for PC Logo

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