Should 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 |
Should I use a macro for this function?
If you actually see:
11:22:33AM in a cell, then in another cell: =LEFT(A1,8) & " " & RIGHT(A1,2) -- Gary''s Student - gsnu200774 "dwny" wrote: 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 |
Should I use a macro for this function?
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 "Gary''s Student" wrote: If you actually see: 11:22:33AM in a cell, then in another cell: =LEFT(A1,8) & " " & RIGHT(A1,2) -- Gary''s Student - gsnu200774 "dwny" wrote: 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 |
Should I use a macro for this function?
You are very welcome!
-- Gary''s Student - gsnu200774 "dwny" wrote: 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 "Gary''s Student" wrote: If you actually see: 11:22:33AM in a cell, then in another cell: =LEFT(A1,8) & " " & RIGHT(A1,2) -- Gary''s Student - gsnu200774 "dwny" wrote: 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 |
All times are GMT +1. The time now is 03:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com