 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / May 2008Formatting Date Field
Good day, i have a problem where i have imported some data with dates and time, the problem is i need to modify the time part of the date to a specific time like 18:00:00. The dates came in as follows 05/09/2008 18:00:00 10/10/2008 18:00:00 23/10/2008 18:00:00 05/12/2008 16:01:00 28/11/2008 18:00:00 05/12/2008 10:00:00 06/06/2008 18:00:00 27/06/2008 18:00:00 18/07/2008 12:35:00 22/08/2008 18:00:00 How can i change them to all have a finish time of 18:00:00? Please note that this is a sample from over 2,000 dates i have to modify. Help Please!!! incoming dates beeing in column A =INT(A2)+0.75 and format result cells as date/time Regards, Stefi „whatzzup” ezt írta: > Good day, i have a problem where i have imported some data with dates and > time, the problem is i need to modify the time part of the date to a specific [quoted text clipped - 13 lines] > > Help Please!!! Thanks Stefi, but the entire date string is in on cell, all i need to do is to change the time section, i can do this easily in search and replace but because they are random times i would have to know what they are in the first place to change them to 18:00:00 > incoming dates beeing in column A > =INT(A2)+0.75 [quoted text clipped - 21 lines] > > > > Help Please!!! I see, if they are strings instead of Excel date/time values, then use this formula: =LEFT(A2,11)&"18:00:00" You can overwrite the original values with Copy/PasteSpecial-Values, if necessary. Regards, Stefi „whatzzup” ezt írta: > Thanks Stefi, but the entire date string is in on cell, all i need to do is > to change the time section, i can do this easily in search and replace but [quoted text clipped - 26 lines] > > > > > > Help Please!!! Thanks Stefi, it work a charm > I see, if they are strings instead of Excel date/time values, then use this > formula: [quoted text clipped - 37 lines] > > > > > > > > Help Please!!! You are welcome! Thanks for the feedback! Stefi „whatzzup” ezt írta: > Thanks Stefi, it work a charm > [quoted text clipped - 39 lines] > > > > > > > > > > Help Please!!! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.