Question about Microsoft Excel for PC

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

Posted by on

• Fred Block May 11, 2010

• Gerald Russell May 11, 2010

turn around time for???

×

• 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

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

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

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

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

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

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

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

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

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

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

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

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

### ACER POWER

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

Jun 12, 2008 | Acer Aspire 3680 Laptop

## Open Questions:

#### Related Topics:

90 people viewed this question

Level 3 Expert

Level 3 Expert