Forum Discussion
Formatting time
I am doing a time study and have some date time data that was given to me in a format where the time does not have a colon in it so formatting the cells is not working. Is there a way to easi...
Try this formula, formatted as "mm/dd/yyyy hh:mm":
=DATEVALUE(LEFT(A1,8))+
TIME(MID(A1,10,2),
RIGHT(A1,2),0)