 |
 | 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 / March 2008Should I use a macro for this function?
The Time stamp data that comes to me is in this format hh:mm:ssAM, and to use the data I need to put a space between the seconds and AM (or PM). Doing this manually is grueling so I recorded a macro but the macro changes the data to the data in the cell in which it was recorded. So I'm not sure what the right solution is and appreciate any guidance. Thank you. Doug If you actually see: 11:22:33AM in a cell, then in another cell: =LEFT(A1,8) & " " & RIGHT(A1,2)  SignatureGary''s Student - gsnu200774 > The Time stamp data that comes to me is in this format hh:mm:ssAM, and to > use the data I need to put a space between the seconds and AM (or PM). Doing > this manually is grueling so I recorded a macro but the macro changes the > data to the data in the cell in which it was recorded. So I'm not sure what > the right solution is and appreciate any guidance. Thank you. Doug Consider me one of your students.....thank you so much....when time changes to 1 pm there's only 7 characters so I changed the formula and will simply use 2 for the worksheets.....once again, thank you, Regards, Doug > If you actually see: > [quoted text clipped - 9 lines] > > data to the data in the cell in which it was recorded. So I'm not sure what > > the right solution is and appreciate any guidance. Thank you. Doug You are very welcome! SignatureGary''s Student - gsnu200774 > Consider me one of your students.....thank you so much....when time changes > to 1 pm there's only 7 characters so I changed the formula and will simply [quoted text clipped - 13 lines] > > > data to the data in the cell in which it was recorded. So I'm not sure what > > > the right solution is and appreciate any guidance. Thank you. Doug |
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.