How to change raw time data from 07:05:00 to 07:05:00 AM? Not able by format

[teodora bocarski]

I have tried by format cells and it was not successfuly. Tried manualy to add to 07:05:00 AM and it changed under fx as 07:05:00 AM also same in the table. Export has a lot of times so it is not easy to do it manually. Any advice? Thanks in advance

 

[Dave Patton]

Dates and Time 2024.xlsm
	A	B	C
1
2	Text	07:05:00	8
3		7:05:00 AM
4
5		07:05:00
6		07:05:00
7
3c

Cell Formulas
Range	Formula
C2	C2	=LEN(B2)

Your import may show the information as text.
Check the length of the string in a cell.
If the length is 8, try one of the following:
a) copy a blank cell
move to a relevant cell and Paste Special Add
Format the number with a Time Format
b) select a range such as B5:B6
Use Data TextToColumns
click through the screens and click on Finish
then format with Time Format

 

[teodora bocarski]

Thank you very much!!! I did as you said