I have data with date and time together, I was trying to separate them in a new column. When I put the formula and press enter the number came to the new column but are different. It change the number at the date and the time.
Example The formula =Right(A2,8) to get what is at the right I count everything that I need, the number are like this 02:34:54, it came back like this 75694444. The date was 2017-09-01 the formula for the date was =left(A2,10) came back 42979.00140. I did the same formula in google sheet with no problem.
New contributor
Yomaris Ortiz Yomy is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.