Forum Discussion

Copper Contributor

Dec 31, 2022

Solved

Text to Date conversion

Hi, I have a scenario say I am receiving a file say at date time "2022-12-15 11.02.29.965", I start processing the file at date time "2022-12-15 11.02.36.104" and it takes time "00 00:00:00.105" ...

excel

fahadozair
Dec 31, 2022
HansVogelaar

Thanks a lot Hans for your Help and Support. It is working.

Could you please also let me know how to convert "00 00:00:00.105" to time format so that I can add it to "2022-12-15 11.02.36.104" so that output is something like "2022-12-15 11.02.36.209"

HansVogelaar

MVP

Dec 31, 2022

fahadozair

Let's say you have such a value in A2.

Try the following formula in another cell to convert it:

=1*SUBSTITUTE(SUBSTITUTE(A2,".",":",1),".",":",1)

If it works, the result will look like a number. Format the cell with the formula as date and time.

fahadozair
Copper Contributor
Dec 31, 2022
HansVogelaar

Thanks a lot Hans for your Help and Support. It is working.

Could you please also let me know how to convert "00 00:00:00.105" to time format so that I can add it to "2022-12-15 11.02.36.104" so that output is something like "2022-12-15 11.02.36.209"
- HansVogelaar
  MVP
  Dec 31, 2022
  fahadozair
  
  With a time string in A3, use
  
  =1*MID(A3,4,12)
  
  You can add this to the converted date/time.
  - fahadozair
    Copper Contributor
    Dec 31, 2022
    Once again Thanks a lot Hans for your help and support. Greatly Appreciated.