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...
Hi Nabil,
This process did not work. The formatting is not recognizing and converting the time part. Any other suggestions?
Thanks!
Another variant of above formula
=LEFT(A1,8)+(INT(RIGHT(E1,4)/100)+MOD(RIGHT(E1,4),100)/60)/24