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