Convert Date/Time Format

[Bullflip]

How do I convert the following:

2/24/2022 10:02:11 AM

To this:
2/24/2022 10:12:11

How do I just drop the AM part? For some reason, Tableau won't read the first one, but it reads the second one.

 

[etaf]

is it a format issue ? or is it entered as text

format the cell to general and see if you just get a number

then use format
mm/dd/yyyy h:mm:ss

 

[Bullflip]

is it a format issue ? or is it entered as text

format the cell to general and see if you just get a number

then use format
mm/dd/yyyy h:mm:ss

Hi, I tried formatting it to general and it stays the same. So I think it's entered in as text.

 

[etaf]

if its text , you will need VBA to change the cell contents themselves
a formula will have to be in a different cell

do you want in a different cell if not - VBA not my area

will months / days with single digits have a leading zero
02/03/2022
OR
2/3/2022

 

[jtakw]

Hi,

You should be able to do just this, then, copy/paste/value into the original cell if you want:

Book3.xlsx
	A						G
12	2/24/2022 10:02:11 AM
13	2/24/2022 10:02:11						<format as m/d/yyyy h:mm:ss
14							or however you want
Sheet1032

Cell Formulas
Range	Formula
A13	A13	=A12+0

 

[jtakw]

Also try:

Select your Text date cell
Click on "Data" Tab, Click "Text to Columns"
Click "Finish"

It should change your Text date to Real Date, then format to display as you like.

 

[Bullflip]

Also try:

Select your Text date cell
Click on "Data" Tab, Click "Text to Columns"
Click "Finish"

It should change your Text date to Real Date, then format to display as you like.

Thank you!

 

[jtakw]

You're welcome.