Should I use a macro for this function?

  • Thread starter Thread starter dwny
  • Start date Start date
D

dwny

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)
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pasting cell contents into a macro 1
Select drop down menu option using libre-calc macro 0
Pivot table macro filter data between yesterday and today (date+time) 0
writing a sort macro 2
Macro for data and time 2
macro help 4
Advanced Filter Macro Failing 4
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0

Back
Top