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"

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.