Forum Discussion
Solved
Need To Convert Data In Cell To Date and Time
Hello, normally I am pretty good at writing my own formulas, but for some reason this one has me a little stumped. We have a website with forms that clients enter information in, and that info is set...
As variant
=LEFT(A1,10) + MID(A1,12,10) + MID(A1,21,3)/24/60/60/1000 - 8/24
As variant
=LEFT(A1,10) + MID(A1,12,10) + MID(A1,21,3)/24/60/60/1000 - 8/24
You are welcome
Thank you so much! You are amazing! I was even able to modify it so we could change the date to a more standard format. I do appreciate it!
