Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
remove the date, leave the time
Hi all. I have a problem. I have a data set that must be copied and pasted
into Excel and one of the columns contains a date and time in this format: 3/31/2010 4:18:00 PM (ET) Now I can do a simple search and replace to get rid of the (ET) part, but what I want to do is this. If the data is in cell €˜A1, I want to have cell C1 show JUST the time in a 24hr format. Is there a way to strip the date data out and convert the time to 24hr format? Thanx! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove Time from Date | Excel Discussion (Misc queries) | |||
How do I remove an item from my legend, but leave it on my graph? | Charts and Charting in Excel | |||
Remove the Formula but leave the value alone? | New Users to Excel | |||
Remove Time Element of a Date | Excel Worksheet Functions | |||
Remove time from a date and time field? Format removes the displa. | Excel Worksheet Functions |