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...
You may use formula like
=DATEVALUE(LEFT(A1,8))+TIMEVALUE(MID(A1,10,2)&":"&RIGHT(A1,2))
for the first cell in next column, select this column starting from this cell till end of the range, Ctrl+D. On the range Ctrl+1 and apply custom mm/dd/yy hh:mm format to the range.
That is assuming mm/dd/yy is your default format for the date.