I really do appreciate ya'll trying to help. I tried to use both codes but I got a type missmatch error.
"Type missmatch in argument. The function requires a String but inferred was a Number"
Thank again for your's help.
I need help converting a string to a date time. My string in the format 20,121,109 for the date and 3,325 for the time. This should convert to 11/9/2012 with a time of 0:33:25. I'm using the formula below to convert it but when the time is between midnight and 1 my times are all messed up...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.