I have the above raw data. I want to split the time into "00:00" format.
When I enter "=Left(A2,2)&":"&right(a2,2)
I am getting 95:50
This means its not counting zero on the first cell.
Is there a go around for this? I couldn't find any on internet