Question about Microsoft Excel Computers & Internet
Comp Avgdays user Waitshop in Shop Wait part Wait pickup 67 12.73 12.73 0.76 3.07 11.17 0.16 how do I get the calculation for the turn around time for waiting pickup which is 0.16
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
Posted on Jan 02, 2017
SOURCE: Calculated field in Excel pivot
Count will only work with numbers. So select another box where you want your number and use this formula: =count(x:x) This should give the count number then you will need to find the difference. In another box, use =sum(x-x). This should give you your difference.
If this helps you, please rate me. Thanks, Patty
Posted on Dec 30, 2007
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:
Posted on Dec 19, 2008
The most common reason for slow processing speed is insufficient RAM memory.
Increase the RAM, if RAM available is no more than 512MB, then it must be upgraded.
Check also your hard drive state. If you have less than 1GB free, that will slow down the system. Go to Start>>Programs>Accessories>System Tools>Disk Defregmenter and do a Defrag of the hard disk.
If you have at least 1 GB RAM, and you took care of the hard drive, then you can check the process starting up on their own and remove the useless one, or spot mala-ware that can affect speed. You can use a software like Hijack This, and search on google te function of each process started on the list reported by the software.
You can download Hijack this here MajorGeeks | If download does not start, then click at the top of the page, where it says Click Here If It Does Not.
Be careful if you delete the wrong files using this software you can harm the system, and Windows may not work properly.
If you think you have malaware you can also install Spy Bot, and do a system scan. Download Spybot from The home of Spybot.
If all the above does not work, and there is no malaware, then you usually reinstall the system.
Check also the bios settings, BIOS can downgrade the CPU speed on default , even if this is uncommon on recent BIOS.
If a computer is still slow with a fresh system and enough resources then it is one of those rare occasions when you have an hardware fault.
Hardware that can cause slow down is: RAM CPU Motherboard HD Video card.
Some tips on procedure can damage your windows installation. Do not download Hijackthis software and do not change BIOS settings and do not touch hardware unless you are sure of what you are doing.
Posted on May 21, 2009
SOURCE: cannot select calculate fields
maggie57, I also have the same problem, but I have discovered a workaround. Use the spacebar to select/deselect individual items in the field chooser.
Posted on Jul 14, 2010
SOURCE: Hello Please can you help. We
This is usually caused by the user not having full rights to the Data directory. right click on the data director select security and you can a click on users network logon and tick on full control
Posted on Nov 15, 2010
Tips for a great answer:
Oct 21, 2015 | The Computers & Internet
Aug 26, 2015 | The Computers & Internet
Nov 19, 2012 | Linksys Wireless-G WRT54G Router
May 26, 2012 | Casio FX-260 Calculator
Feb 28, 2010 | Sharp EL-1801P Calculator
Jan 30, 2010 | Texas Instruments TI-84 Plus Calculator
Jan 14, 2009 | Computers & Internet
Jun 27, 2008 | Toshiba Satellite A205-S4617 Notebook
Jun 04, 2008 | Casio FX-260 Calculator
37 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: