First, a posting tip:Try tossing in some punctuation and capitalization every now and then. When you post one long "sentence" with no periods it makes your post very hard to read.If you are sure that the cell is blank, then you can force a blank to be returned with this formula:=IF(VLOOKUP(A2,$D$6:$Read more
First, a posting tip:
Try tossing in some punctuation and capitalization every now and then. When you post one long “sentence” with no periods it makes your post very hard to read.
If you are sure that the cell is blank, then you can force a blank to be returned with this formula:
Here is the complete formula, it will diaplayYears, Months, Days, Hours, Minutes, Seconds.Again,Put your Start Date in cell B1Put your End Date in cell D1Put the below formula in F1This is all one formula:=IF(D1="",DATEDIF(B1,NOW()-(MOD(B1,1)>MOD(NOW(),1)),"y")&" years, "&DATEDIF;(B1,NOW(Read more
Here is the complete formula, it will diaplay Years, Months, Days, Hours, Minutes, Seconds.
Again, Put your Start Date in cell B1 Put your End Date in cell D1 Put the below formula in F1
This is all one formula:
=IF(D1=””,DATEDIF(B1,NOW()-(MOD(B1,1)>MOD(NOW(),1)),”y”)&” years, “&DATEDIF;(B1,NOW()-(MOD(B1,1)>MOD(NOW(),1)),”ym”)&” months, “&DATEDIF;(B1,NOW()-(MOD(B1,1)>MOD(NOW(),1)),”md”)&” days, “&TEXT;(MOD(NOW()-B1,1),”hh “” hours, “” mm “” minutes, and “” ss “”seconds”””),DATEDIF(B1,D1-(MOD(B1,1)>MOD(D1,1)),”y”)&” years, “&DATEDIF;(B1,D1-(MOD(B1,1)>MOD(D1,1)),”ym”)&” months, “&DATEDIF;(B1,D1-(MOD(B1,1)>MOD(D1,1)),”md”)&” days, “&TEXT;(MOD(D1-B1,1),”hh “” hours, “” mm “” minutes, and “” ss “”seconds”””))
What happens if you press Ctrl-F?That is the key sequence to bring up the Find and Replace dialog box.If it has really disappeared from the Edit menu, try this:1 - Tools...Customize...Commands tab2 - Under Categories, select Edit3 - On the Commands side, scroll down to Find...4 - Click on Find..., hRead more
What happens if you press Ctrl-F?
That is the key sequence to bring up the Find and Replace dialog box.
If it has really disappeared from the Edit menu, try this:
1 – Tools…Customize…Commands tab 2 – Under Categories, select Edit 3 – On the Commands side, scroll down to Find… 4 – Click on Find…, hold the mouse button down and Drag it over the word Edit on the toolbar. 5 – When the Edit menu opens, drag the Find button to wherever you want it and release the mouse. 6 – If Replace is also missing, drag that button up also.
Use......sudo alsamixer.....in the terminal.When that is open use the L/R arrow keys to move across the bottom of the screen and the up/down arrows to adjust the volume of all channels.Mint 17.3 gave me the same problem you describe.
Use……sudo alsamixer…..in the terminal.
When that is open use the L/R arrow keys to move across the bottom of the screen and the up/down arrows to adjust the volume of all channels.
WPS stands for Wi-Fi Protected setup. The button will be on your wireless router. Have a look at http://www.ehow.com/how_8785241_sig... .Note that WPS is often disabled as it has security issues.
The bios won't need a driver but any hardware it enables would. If you enable it then on reboot and go into device manager and see if any of the hardware listed is showing a yellow question mark or exclaimation point indicating it needs a driver. If this crystal beach needs a driver it should be onRead more
The bios won’t need a driver but any hardware it enables would. If you enable it then on reboot and go into device manager and see if any of the hardware listed is showing a yellow question mark or exclaimation point indicating it needs a driver. If this crystal beach needs a driver it should be on the support page for your motherboard.
What happened to the original AC adapter for the laptop ? If the AC adapter is putting out the proper voltage - 18.5 v - if the polarity of the voltage at the plug is correct - center positive , and if there's nothing wrong with the battery, then the plug that plugs into the laptop's jack should NOTRead more
What happened to the original AC adapter for the laptop ?
If the AC adapter is putting out the proper voltage – 18.5 v – if the polarity of the voltage at the plug is correct – center positive , and if there’s nothing wrong with the battery, then the plug that plugs into the laptop’s jack should NOT get HOT. Either you have a problem with the plug you’re using, or with cord near that plug, or you have a problem with the jack or the jack’s connection inside the laptop.
If the universal AC adapter has multiple plugs, the proper plug has the largest external diameter that will fit in the laptop’s jack, and the smallest center hole that will fit over the center pin in the jack. The diameter of the center hole is more critical that the outside diameter – it that’s too big you’re likely to have problems charging the battery and powering the laptop on the AC adapter alone.
If the battery gets HOT when the AC adapter is plugged in as I described, and if the AC adapter is putting out the proper voltage, it’s polarity at the plug is correct, and if you’re using the proper plug, it probably IS internally shorted, no matter how old it is ! …..
For maximum battery charging capacity you should “calibrate” the battery.
Here's how I got it solved:removed DVD drive, HDD, WiFi adapter, RAM module.Started up, screen obviously remained blank.Shutdown, RAM in, start.Now it displayed attempting to use LAN adapter for booting, with no success.Restarted, entered BIOS, disabled network boot.Shot down, inserted HDD.Success -Read more
Here’s how I got it solved:
removed DVD drive, HDD, WiFi adapter, RAM module. Started up, screen obviously remained blank. Shutdown, RAM in, start. Now it displayed attempting to use LAN adapter for booting, with no success. Restarted, entered BIOS, disabled network boot. Shot down, inserted HDD. Success – booted straight into Windows! Shutdown, inserted WiFi adapter. Success again. Shutdown, inserted DVD drive. Success, no errors.
What I think it was is that BIOS got confused after old HDD was replaced (it’s hard to tell because particular BIOS does not show just much) and remained to poll LAN adapter as boot priority on background somehow. Anyway, by removing and reinserting devices as above I was able to find what looked like a cause of conflict. Whether the trick lies in disabling network boot or reinserting devices in certain order…don’t mind to try again until facing the same problem again, honestly…
Get yourself a thermometer for down there.You can get inexpensive devices that monitor the relative humidity in the air. Use one of those in the basement. If it shows, say, 70% or less, you're fine. This guy in a recent Topic has his computer in a cool room that has shown as low was 11C (51.8 F) inRead more
Get yourself a thermometer for down there.
You can get inexpensive devices that monitor the relative humidity in the air. Use one of those in the basement. If it shows, say, 70% or less, you’re fine.
This guy in a recent Topic has his computer in a cool room that has shown as low was 11C (51.8 F) in the current bios readings and it seems to be working fine. See Response 58 and 59 https://computing.net/answers/ha…
He quoted the temp outside too. That’s not relevant. The temp where I am was -38 C outside on one day a short while before Xmas, but where my computer is in the heated and insulated basement never gets below about 15 C or so (59 F) in the winter, and that’s only when we’re sleeping – we keep the furnace thermostat upstairs set to no less than 20 C (68 F) at night – it might get a bit cooler there in the spring and fall when the furnace doesn’t come on as often.
The original problem sounds like just a bad cmos battery. Replace it if you haven't already. Your power supply doesn't need to be replaced. Then pray you can get into cmos/bios setup and make the necessary corrections and didn't mess things up with a bad bios flash. Be sure to set the date and time.
The original problem sounds like just a bad cmos battery. Replace it if you haven’t already. Your power supply doesn’t need to be replaced. Then pray you can get into cmos/bios setup and make the necessary corrections and didn’t mess things up with a bad bios flash. Be sure to set the date and time.
Solved Using Vlookup To Return a Blank Instead Of 00/01/1900
First, a posting tip:Try tossing in some punctuation and capitalization every now and then. When you post one long "sentence" with no periods it makes your post very hard to read.If you are sure that the cell is blank, then you can force a blank to be returned with this formula:=IF(VLOOKUP(A2,$D$6:$Read more
Try tossing in some punctuation and capitalization every now and then. When you post one long “sentence” with no periods it makes your post very hard to read.
If you are sure that the cell is blank, then you can force a blank to be returned with this formula:
=IF(VLOOKUP(A2,$D$6:$E$7,2,0)=””,””,VLOOKUP(A2,$D$6:$E$7,2,0))
Click Here Before Posting Data or VBA Code —> How To Post Data or Code.
Solved How To Create a Real-Time Counter In Excel
Here is the complete formula, it will diaplayYears, Months, Days, Hours, Minutes, Seconds.Again,Put your Start Date in cell B1Put your End Date in cell D1Put the below formula in F1This is all one formula:=IF(D1="",DATEDIF(B1,NOW()-(MOD(B1,1)>MOD(NOW(),1)),"y")&" years, "&DATEDIF;(B1,NOW(Read more
Years, Months, Days, Hours, Minutes, Seconds.
Again,
Put your Start Date in cell B1
Put your End Date in cell D1
Put the below formula in F1
This is all one formula:
=IF(D1=””,DATEDIF(B1,NOW()-(MOD(B1,1)>MOD(NOW(),1)),”y”)&” years, “&DATEDIF;(B1,NOW()-(MOD(B1,1)>MOD(NOW(),1)),”ym”)&” months, “&DATEDIF;(B1,NOW()-(MOD(B1,1)>MOD(NOW(),1)),”md”)&” days, “&TEXT;(MOD(NOW()-B1,1),”hh “” hours, “” mm “” minutes, and “” ss “”seconds”””),DATEDIF(B1,D1-(MOD(B1,1)>MOD(D1,1)),”y”)&” years, “&DATEDIF;(B1,D1-(MOD(B1,1)>MOD(D1,1)),”ym”)&” months, “&DATEDIF;(B1,D1-(MOD(B1,1)>MOD(D1,1)),”md”)&” days, “&TEXT;(MOD(D1-B1,1),”hh “” hours, “” mm “” minutes, and “” ss “”seconds”””))
You’d best copy and paste.
MIKE
http://www.skeptic.com/
Excel Find Function
What happens if you press Ctrl-F?That is the key sequence to bring up the Find and Replace dialog box.If it has really disappeared from the Edit menu, try this:1 - Tools...Customize...Commands tab2 - Under Categories, select Edit3 - On the Commands side, scroll down to Find...4 - Click on Find..., hRead more
That is the key sequence to bring up the Find and Replace dialog box.
If it has really disappeared from the Edit menu, try this:
1 – Tools…Customize…Commands tab
2 – Under Categories, select Edit
3 – On the Commands side, scroll down to Find…
4 – Click on Find…, hold the mouse button down and Drag it over the word Edit on the toolbar.
5 – When the Edit menu opens, drag the Find button to wherever you want it and release the mouse.
6 – If Replace is also missing, drag that button up also.
Solved Sound Blaster Audigy SE Soundcard On Linux Mint 17.2
Use......sudo alsamixer.....in the terminal.When that is open use the L/R arrow keys to move across the bottom of the screen and the up/down arrows to adjust the volume of all channels.Mint 17.3 gave me the same problem you describe.
When that is open use the L/R arrow keys to move across the bottom of the screen and the up/down arrows to adjust the volume of all channels.
Mint 17.3 gave me the same problem you describe.
Solved What Is a WPS Button On An iPad
WPS stands for Wi-Fi Protected setup. The button will be on your wireless router. Have a look at http://www.ehow.com/how_8785241_sig... .Note that WPS is often disabled as it has security issues.
Note that WPS is often disabled as it has security issues.
What Is Crystal Beach
The bios won't need a driver but any hardware it enables would. If you enable it then on reboot and go into device manager and see if any of the hardware listed is showing a yellow question mark or exclaimation point indicating it needs a driver. If this crystal beach needs a driver it should be onRead more
Tip Of Laptop Charger Melted. Charger Barely Charges Laptop
What happened to the original AC adapter for the laptop ? If the AC adapter is putting out the proper voltage - 18.5 v - if the polarity of the voltage at the plug is correct - center positive , and if there's nothing wrong with the battery, then the plug that plugs into the laptop's jack should NOTRead more
If the AC adapter is putting out the proper voltage – 18.5 v – if the polarity of the voltage at the plug is correct – center positive , and if there’s nothing wrong with the battery, then the plug that plugs into the laptop’s jack should NOT get HOT.
Either you have a problem with the plug you’re using, or with cord near that plug, or you have a problem with the jack or the jack’s connection inside the laptop.
If the universal AC adapter has multiple plugs, the proper plug has the largest external diameter that will fit in the laptop’s jack, and the smallest center hole that will fit over the center pin in the jack. The diameter of the center hole is more critical that the outside diameter – it that’s too big you’re likely to have problems charging the battery and powering the laptop on the AC adapter alone.
(DC plug) Connecter size:
Internal Diameter: 1.7mm
External Diameter: 4.8mm
If the battery gets HOT when the AC adapter is plugged in as I described, and if the AC adapter is putting out the proper voltage, it’s polarity at the plug is correct, and if you’re using the proper plug, it probably IS internally shorted, no matter how old it is !
…..
For maximum battery charging capacity you should “calibrate” the battery.
HP Notebook PCs – Calibrating the Notebook Battery in Microsoft Windows 98, ME, XP, and 2000
http://h10025.www1.hp.com/ewfrf/wc/…
Resource Conflict – PCI On Motherboard Bus:00
Here's how I got it solved:removed DVD drive, HDD, WiFi adapter, RAM module.Started up, screen obviously remained blank.Shutdown, RAM in, start.Now it displayed attempting to use LAN adapter for booting, with no success.Restarted, entered BIOS, disabled network boot.Shot down, inserted HDD.Success -Read more
removed DVD drive, HDD, WiFi adapter, RAM module.
Started up, screen obviously remained blank.
Shutdown, RAM in, start.
Now it displayed attempting to use LAN adapter for booting, with no success.
Restarted, entered BIOS, disabled network boot.
Shot down, inserted HDD.
Success – booted straight into Windows!
Shutdown, inserted WiFi adapter. Success again.
Shutdown, inserted DVD drive. Success, no errors.
What I think it was is that BIOS got confused after old HDD was replaced (it’s hard to tell because particular BIOS does not show just much) and remained to poll LAN adapter as boot priority on background somehow.
Anyway, by removing and reinserting devices as above I was able to find what looked like a cause of conflict. Whether the trick lies in disabling network boot or reinserting devices in certain order…don’t mind to try again until facing the same problem again, honestly…
Is It Safe To Leave My Computer In Cold Temp?
Get yourself a thermometer for down there.You can get inexpensive devices that monitor the relative humidity in the air. Use one of those in the basement. If it shows, say, 70% or less, you're fine. This guy in a recent Topic has his computer in a cool room that has shown as low was 11C (51.8 F) inRead more
You can get inexpensive devices that monitor the relative humidity in the air. Use one of those in the basement. If it shows, say, 70% or less, you’re fine.
This guy in a recent Topic has his computer in a cool room that has shown as low was 11C (51.8 F) in the current bios readings and it seems to be working fine.
See Response 58 and 59
https://computing.net/answers/ha…
He quoted the temp outside too. That’s not relevant.
The temp where I am was -38 C outside on one day a short while before Xmas, but where my computer is in the heated and insulated basement never gets below about 15 C or so (59 F) in the winter, and that’s only when we’re sleeping – we keep the furnace thermostat upstairs set to no less than 20 C (68 F) at night – it might get a bit cooler there in the spring and fall when the furnace doesn’t come on as often.
Bad Bios Checksum, After Flash Bios, Recovery Fail
The original problem sounds like just a bad cmos battery. Replace it if you haven't already. Your power supply doesn't need to be replaced. Then pray you can get into cmos/bios setup and make the necessary corrections and didn't mess things up with a bad bios flash. Be sure to set the date and time.
The original problem sounds like just a bad cmos battery. Replace it if you haven’t already. Your power supply doesn’t need to be replaced. Then pray you can get into cmos/bios setup and make the necessary corrections and didn’t mess things up with a bad bios flash. Be sure to set the date and time.