LinkBack URL
About LinkBacks
Hi all,
Refer attachment,
Earlier on i could change the format of the cloumn to HH:MM in customs/format cell but now its not possible. Can u please help and explain whats wrong ??
Apprecaite your help.
Hi all,
Refer attachment,
Earlier on i could change the format of the cloumn to HH:MM in customs/format cell but now its not possible. Can u please help and explain whats wrong ??
Apprecaite your help.
Data Menu ->Text-to-column -->delimet6ed ->> date...
Then format to HH:MM
the dates/time are treated as text that's why you can format it.
hth.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Hi hafeezcloud
I have posted a solution in your other thread which is now closed.
Have a look at this file and see if that will be of a help!
Hi. I have downloaded the file and its doesnt solve my issue. The dates are for september whereas yours show october.
Just change the format in column C...of Kevin solution.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Hi hafeezcloud
I am not sure what you mean. The dates in your file are dates, until you reach row 521 and onwards you have a mixture of dates and text.
With reference to your other thread, which as been closed due to being a duplicate post.
The formula in the file I uploaded addresses the text dates. Please see the picture:The date is format is MM:DD:YY and i would like to format it to DD:MM:YY and display it as 10-Sep-2012.
hafeezcloud-Dates.jpg
As you can see in cell A521 the date is 9/13/2012 as described in your original thread. mm/dd/yyyy. In cell C521 it is as you requested, dd/mm/yyyy.
Thank you Fotis1991
Kevin
I have noticed that it is a different file you have attached to this thread. Same formula:
Hi Kevin,
I will try and explain what i am actually looking for. Earlier on i used to select column A , right click to format cells and then go to customs any type HH:MM, i used to have the results instantly without any forumula or Text to Column option. But not its not happening so. I dont understand why it so.
I want to select Column A and then go to format cells and then custom it to HH:MM direclty.
Hope i clear now. Appreciate your response.
Hi hafeezcloud
In post #1 of this thread, you have uploaded file named: Book20.xlsx
In column A: A2:A7 you have a series of dates and times. Which are text and not a number, so you can not format the text as hh:mm. For example when there is aDate/Time in a cell, if you select the cell and format as "General", there will be a serial number displayed. See attached work sheet.
Ok .. thnx fr the help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks