Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using macro or other function | Excel Discussion (Misc queries) | |||
Sub Macro vrs Function Macro Auto Start | Excel Discussion (Misc queries) | |||
Macro within a function? | Excel Worksheet Functions | |||
Macro With IF Function | Excel Worksheet Functions | |||
macro or function | Excel Worksheet Functions |