split a date/time column ie. mm/dd/yy hh:mm:ss AM/PM. Into 2 columns

How to split a date/time column ie. mm/dd/yy hh:mm:ss AM/PM into 2 columns

Suppose I want to split a date/time column ie. mm/dd/yy hh:mm:ss AM/PM into 2 columns as below:
1. mm/dd/yy
and
2. hh:mm

How do I do it?

Here is the solution:

1. =int(A1), format as date
2. =MOD(A1,1), format as time

Source

10 ways to access blocked Gmail at office, school, work

Accessing email using Gmail is daily routine for many web users. Usually, work / school places do not like open access to Gmail as it results in people spending more time checking personal stuff on Gmail. Incase IT guys at your place has blocked Gmail access, here are few ways to bypass it.

1. Use different access URL - Get started by using a different URL web address to access Gmail instead of using www.gmail.com. You IT admin might have forgotten to block some URLs.
 -  http://gmail.com or https://gmail.com
 -  http://m.gmail.com or https://m.gmail.com
 -  http://googlemail.com or https://googlemail.com
 -  http://mail.google.com/mail/x/ or https://mail.google.com/mail/x/

    

2. Use Proxy websites to get through – There are thousands of proxy websites which can be used to access Gmail blocked in office, school or at work. See lists: here, here and here.

3. Download Gmail messages using Email Client – Instead of web browser access of Gmail, you can configure an Email client to download Gmail messages. You can use Outlook, Apples Mail, Windows Mail, Thunderbird. [See setup details here]

   

4, Access Gmail via Google Desktop - If you have permission to install software on your work computer that installing Google Desktop might serve the purpose. You can access Gmail using this application without getting into restrictions imposed by IT admin at your place – might just work!

5. Create password free Gmail feed - We have already disccused in detail about web service called ‘FreeMyFeed’. It allows you to generate password free RSS Feed which can be used to access Gmail contents in a web based RSS reader. Note: use discretion while sharing login details.

6. Access through iGoogle - You can try to access Gmail using iGoogle login URL [http://www.google.com/ig]. After login you can see latest Gmail messages on the left sidebar.

   

7. Use a website with Gmail Lite installed - You can use 3rd party websites (risky thing) which Gmail Lite software installed. Bump into few of them here at Google Search.

8. Access Gmail from Google Talk - If you have Google Talk installed on office computer, click the Gmail icon next to view button on Gtalk window. This might work, if your IT guys were too lazy to block it.

9. Make friends in IT department - If nothing works, how about getting little friendly with IT department staff? They might relax Gmail blocking for sometime so that you can get over Gmail addiction. Give it a shot, might work – we are humans!



10. Over to you - If none of the above work in trying to access blocked Gmail at work, office or school – give credit to your IT guys, they are very smart! Now its over to you, do you know any other way to get over blocked Gmail? Let us know by adding a comment.

P.S.Websites are blocked at office, work, school as they are against their policies and retain employee / student productivity. Even though studies suggest blocking websites result in lack of concentration and productivity – stick to rules and dont jump into blocked zone, ok?

  

Source

Office 2007 Ultimate applications will no longer run on my Vista machine.  When attempting to launch any of the applications--e.g. Outlook, Word, or Excel--the error message in the subject is displayed.  I am running as administrator, so it is not a permissions issue.  I created a new administrator account to make sure my other account was not corrupted.  I have now uninstalled and reinstalled Office without success.

   

This is a newer 64-bit moderately high-end laptop that has Office has been running fine on for about two months.


Steps:

1) Go to the directory: %PROGRAMDATA%\Microsoft\Office\Data
2) Delete all files in the directory.
3) Run any office application.
    This only works on Vista and 7

For XP
C:\Documents and Settings\All Users\Application Data\Microsoft\OFFICE\DATA
Delete all files in the directory.
Run any office application.

Note: You may need to validate office again.
Note: For Office 2000/2003, the files are named with OPA11, meaning Office Version 11.
Note: For Office 2007, the files are named with OPA12, meaning Office Version 12

    

Why should you wait for Samsung Galaxy S4

Samsung may plan to get the Galaxy S4 out in Feb 2013.
It is to get 5in Full HD screen. AMOLED 4.99-Inch Screen. It has unveiled a new octa-core Exynos processor.

Samsung Galaxy S4 will land as the first handset to boast an eight-core processor, new reports have suggested that the Exynos 5 Octa Processor, unveiled by Samsung at CES 2013, will feature on the as yet unconfirmed Samsung Galaxy S4 first, marking the device out as the most powerful to date.

Rumors point to a Galaxy S4 with a 4.99-inch 1080P HD display that may include flexible or unbreakable screen tech, a first for a production Galaxy S phone. The video above shows a prototype unbreakable display from Samsung repeatedly hit with a hammer.

Screen Display - Samsung Galaxy S4 will sport 5 inches Super AMOLED touchscreen with 1080x1920 pixel resolutions. Other rumours claimed that GS4 will be equipped with flexible screen displays. Upcoming iPhone 6 is also speculated to boast 5-inch Full HD display.

Processor - Samsung Galaxy S4 is rumoured to have 8-core processor paired with 2GB RAM. iPhone 6 will probably powered by an updated A6 chip.

Operating System - Samsung Galaxy S4 is speculated to run with the upcoming version of the Android OS - Key Lime Pie or the new mobile software TIZEN OS. iPhone 6, however, will run with iOS 7.

Internal Storage - Samsung Galaxy S3's successor will have 16GB, 32GB and 64GB internal storage with additional storage through microSD slot. iPhone 6, on the other hand, will have a 128GB storage.

4G/LTE - Both devices will support 4G/LTE connectivity.

NFC - Both smartphones will be capable of Near Field Communication. iPhone 5 did not support such feature, which impedes on the sales of the device.

Camera - Samsung Galaxy S4 is rumoured to have a 13MP rear camera. The specific megapixel of iPhone 6's camera is still unknown but rumour hast it that the device will have a super HD camera.

         

  

Source, Source

How to Convert Word Documents to PDFs With Links

I found this very much handy, interesting and easy to use..

1. Open a Microsoft Word document.

2. Select text that you want to appear as a hyperlink.

3. Click the "Insert" tab. Click "Links." Select "Hyperlink."

4. Select the type of link you want to create. To link to a webpage or other file, select "Existing File or Webpage." You also can choose to link to an email address, place in the document or a new file you haven't created yet.

5. Type the address or file name you want to link to in the "Address" field. Click "OK." The hyperlink appears in the document with a blue underline.

6. Save the Word document.

7. Convert the file to PDF by clicking the "Microsoft Office Button." Scroll to "Save as." Click "PDF or XPS."

Please note: If you are unable to see this option, please install the add-in from the following link.

8. Type a new name for the file. Select "PDF" in the "Save as Type" field.

9. Select "Open File After Publishing" to immediately view the document. Click "Publish."

10. View the document in a PDF reader, such as Adobe Reader. 
You should see your underlined hyperlinks. Click one to test it.

2007 Microsoft Office Add-in: Microsoft Save as PDF or XPS

This download allows you to export and save to the PDF and XPS formats in eight 2007 Microsoft Office programs. 

It also allows you to send as e-mail attachment in the PDF and XPS formats in a subset of these programs.

2007 Microsoft Office Add-in: Microsoft Save as PDF or XPS
(SaveAsPDFandXPS.exe, 934 KB)

How to Preserve Hyperlinks When Converting Word Documents to PDF

It is very easy to do so.just follow the following instructions..

1. Open your Microsoft Word document.

2. Highlight the portion of text that you have hyperlinked and then press "Ctrl" and "K" to bring up the hyperlink insertion window.

3. Ensure that the link you have entered in as the "Address" is formatted with an "http://" before the link. 

For example, a link like "http://google.com" will be preserved when converted from a Word document to a PDF, but a link like "google.com" will not be preserved.

Related post: How to Convert Word Documents to PDFs With Links