When the date & time, example: 3/5/2008 1:30 PM is entered into the cell, it can be converted to the 24 hours format. However if the data is extracted from a website to the excel file, the date & time is unable to convert to 24 hours format no matter what options I chose. The same problem encountered by my friends as well. Please advice. Thank You.
Hi,
Sounds like Excel is treating them as TEXT, try this go to Data > Text to cells, and in step 3 select DMY. This should convert the contents to a date format. Then custom format those cells to dd/mm/yyyy hh:mm AM/PM
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
When you extract data from websites it might include extraneous characters, or the spaces in the data might not be actual spaces so it remains a text string rather than being interpreted as a time.
Try oldchippy's suggestion, or perhaps you can convert with a formula in another cell, e.g. with data in A1 try
=LEFT(A1,SEARCH("M",A1))+0
format as required
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks