First of all, How are you importing the data? through a script that reads/writes individual rows, or are you "opening the file" and letting Excel do the mapping?
If you're letting Excel do it, you may have some options for the cell format. Secondly, are you SURE the data is "text". Can you change the display format? Say, change the first two columns to "Long Date". If they change to: Tuesday, November 27, 2012 Saturday, January 00, 1900 Tuesday, November 27, 2012 Saturday, January 00, 1900 or "General" format is: Date In Time 41240 0.583333333 41240 0.65 that indicates that they are numerical instead of Text. Keep in mind that in Excel, a "Date" is simply the number of days since 1/1/1900. and "time" is a fractional part of a day. What we "SEE" as a date, is actually simply one way to display the numerical content. so, to combine date/time, simply add the two: =A2+B2 and change the format to "m/d/yyyy h:mm" (or any other alternative) ----------------------------------- If the cell doesn't change when you change the format, then it truly is text. At which point there is a variety of ways to address the problem, either when importing the data, or once the data is in Excel. Even removing spaces and replacing "/" with "/" in the Date column should cause Excel to "re-evaluate" the contents and convert the date to a number. So, take a look at the contents and let me know what you have so we can formulate an approach to get you where you need to be. Paul ----------------------------------------- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley ----------------------------------------- ________________________________ From: JenIT <jen...@alliedstaffing.com> To: excel-macros@googlegroups.com Sent: Thu, November 29, 2012 12:50:39 PM Subject: $$Excel-Macros$$ convert time formatted as text to military time and join with date field My data is opened from a downloaded file. I do not have an import functions as data exports as excel and I believe my cells are formatted as Text since I cannot seem to make any formatting change the data. I need to to change from it's current format to military time and then also combine the new military time filed with the date filed in front of it. Any help would be greatly appreciated! Date In Time Need the cell to look like this 11/27/2012 02:00 PM 11/27/2012 14:00 11/27/2012 03:36 PM 11/27/2012 15:36 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
