Question about Microsoft Excel for PC

1 Answer

How do I calculate Turn around time in excel excluding sat & sun for 2009

Posted by on

  • Fred Block
    Fred Block May 11, 2010

    Your question is a bit vague. Please explain in more detail.

  • Gerald Russell
    Gerald Russell May 11, 2010

    turn around time for???

×

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    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.

  • Expert
  • 66 Answers

It sounds like you want to determine the number of work days between two days? Use the NETWORKDAYS function. For example, if A1 is 1/4/09 and B1 is 2/4/09, =NETWORKDAYS(A1,B1) will be 23

Posted on Sep 12, 2009

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

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:

2 Answers

What is formula to find percentage of females in my workplace?


      To get around this, you can calculate your numbers as percentages first. For example, if you type the formula =10/100 in cell A2, Excel will display the result as 0.1. If you then format that decimal as a percentage, the number will be displayed as 10%, as you 'd expect.Aug 2, 2011

      How to do percentages in Excel - Office Blogs

      https://blogs.office.com/2011/08/02/how-to-do-percentages-in-excel/
    Feedback

    How to Calculate Percentages in Excel

    www.excelfunctions.net > Excel-Formulas
    Two Percentage Calculation Types. Calculate a Percentage as a Proportion.Calculate Percentage Change. Displaying Percentages in Excel Cells ...

    Excel formula: Get percentage of total ' Exceljet

    https://exceljet.net/formula/get-percentage-of-total
    Excel simply divides the values in column C by the total in C11. For the formula shown, the result is the decimal number .63. Because the Percentage number format is applied to cell E6, Excel displays .63 as 63%.

Jan 19, 2016 | 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

2 Answers

Error message ERR


Product Phone Number Hours Support Website SURFboard® Cable Modems and Gateways 1-877-466-8646 Sun-Sat 7AM-11PM CST Website link Touchstone Cable Modems, Gateways and EMTAs 1-877-682-7747 Sun-Sat 7AM-11PM CST Website link DSL Modems and Gateways 1-877-466-8646 Sun-Sat 7AM-11PM CST Website link Video 1-877-466-8646 Sun-Sat 7AM-11PM CST Website link Software 1-877-466-8646 Mon-Fri 8AM-8PM CST Website link

For other Motorola products, please visit the product's website for your support questions.
Product Phone Number Hours For general product questions and technical support
on your Android-powered Smartphones and Devices
e.g. Motorola XOOM™, DROID RAZR™, DROID Pro,
Motorola ATRIX™ 4G, MOTOACTV™ 1-800-734-5870 Mon-Fri 7AM-10PM;
Sat-Sun 9AM-6PM CST Motorola Fitness Devices
e.g. MOTOACTV 1-800-734-5870 Mon-Fri 7AM-10PM;
Sat-Sun 9AM-6PM CST Non-Android Mobile Phones & Accessories
e.g. Motorola Karma™ QA1, MOTORAZR2™ V9,
MOTO™ W233 renew 1-800-331-6456 Mon-Fri 7AM-10PM;
Sat-Sun 9AM-6PM CST iDEN i-series/ic Series
e.g. i776, i425
(Nextel, Boost Mobile, and Southern Linc) 1-800-453-0920 Mon-Fri 7AM-10PM;
Sat-Sun 9AM-6PM CST TTY Support 1-888-390-6456 Mon-Fri 8AM-5PM CST
reference: http://arris.force.com/consumers/pkb_Home_ConsumerCallUsPage
Call Us

Mar 20, 2014 | Motorola Televison & Video

1 Answer

How do I access the web cam in an acer aspire one notebook


Hi

Acer Technical Support at 1-800-816-2237 M-F 7am-9pm CST and Sat-Sun 8am-5pm CST excluding holidays.

Thanks

Jan 03, 2011 | Acer Aspire One PC Notebook

1 Answer

Are the 7 different programs for 7 different days or are they exclusive?


There are 7 ON events and 7 OFF events
http://waterheatertimer.org/pdf/Woods-59028-59018.pdf

When programming the timer, you select individual days or blocks of days.
For example program1 ON time
Set the Hour
Set the minutes
Press the day key to scroll through the possible choices.
Then you set program1 OFF time
Set the hour
Set the minute
And then press the day key to scroll through the possible choices.

The choices are:
Each individual day
Monday thru Friday
Sat-Sun
Monday thru Sat
Monday thru Sun
Monday-WED-FRI
Tues-Thurs-Sat
Mon-Wed
Thurs-Sat

The key is to set the ON and OFF times for the same days or blocks of days
For example program1 ON is 8:00 am Mon thru Friday
Set program1 OFF for 3:00 pm Mon thru Friday

and then program2 ON is 8:30am Sat-Sun
program2 OFF is 5:00pm Sat-Sun

Program 3 ON is 6:00pm Tues-Thurs-Sat
Program3 OFF is 9:00pm Tues-Thurs-Sat

Program4 ON is 6:00pm Sat
Program4 OFF is 11:00pm Sat

Programs5, 6 and 7 might not be needed

The key is to make a chart of times before setting timer.
The chart will prevent conflicts in programming where the timer does not operate as expected.

Nov 08, 2010 | Coleman Cable Woods 59018 InWall 7Day...

1 Answer

Router logging off by itself.


This problem is difficult to trace.
You could be getting some kind of elecrical/wireless interference. This is difficult to trace. If you have the TV on when the router drops off, have you noticed any electrical interference on the TV screen?
It could be as simple as someone using an arc welder in your area.
Or a neighbour heating up something in their microwave oven (this oven can be faulty and is leaking microwave energy).
If you can identify the source of interference then you may find a solution.
There are a few things you can try.
Get a surge protection power board and connect your computer equipment and wireless router to this power board.
You can configure the wireless router to a different channel, one that is not used by your neighbours so that the wireless signals won't interfer with each other.
Have a look at the signal strength to your computer, if it is weak then move the router away from walls and/or raise it higher to improve the signal strength.

Sep 28, 2009 | Belkin N1 Vision Router

2 Answers

My laptop is only 6 months old and will not boot up.


You will want to contact the manufacturer. They usually have a 1 year parts warrenty on your laptop. The most logical reason is that the mother board(Main PCB) has took a dump. You will want to read the material here: https://secure2.tx.acer.com/FixMyAcer3/FixMyAcer.aspx

Good Luck!

Jan 29, 2009 | Acer Aspire 5315 Notebook

2 Answers

Formula for Calculating the turn around time in excel


dpprash,

I guess you mean the number of weekdays (or working days) excluding Saturdays and Sundays. So start a spreadshhet and put the start date (01/01/2009) in A2 and the end date (31/12/2009?) in B2.

Then paste the formula below into C2:

=B2-A2-2*INT((B2-A2+WEEKDAY(A2,3))/7)-MAX(0,WEEKDAY(B2,3)-4


better-swiss

Dec 18, 2008 | Microsoft Excel for PC

2 Answers

Can't reopen circular reference file in excel


  1. Click the Microsoft Office Button , click Excel Options, and then click the Formulas category.
  2. In the Calculation options section, select the Enable iterative calculation check box.
  3. To set the maximum number of times that Excel will recalculate, type the number of iterations in the Maximum Iterations box. The higher the number of iterations, the more time that Excel needs to calculate a worksheet.
  4. To set the maximum amount of change you will accept between calculation results, type the amount in the Maximum Change box. The smaller the number, the more accurate the result and the more time that Excel needs to calculate a worksheet.

Nov 05, 2008 | Microsoft Excel for PC

3 Answers

ACER POWER


Could be you have a flat battery as your charger is not working

Jun 12, 2008 | Acer Aspire 3680 Laptop

Not finding what you are looking for?
Microsoft Excel for PC Logo

Related Topics:

90 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18385 Answers

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

Answer questions

Manuals & User Guides

Loading...