Excel to Access time conversion issue
Posted on 2007-04-09
Here was my original question:
Excel time format conversion issue
I had an import problem. I imported a time from one spreadsheet to another and got the format mixed up. Unfortunetly, I don't have the old data and don't want to change 25K rows by hand.
Here is what the time looks like in my spreadsheet
This is 47 minutes
It should be this
Can I convert this?
Ok, the accepted answer worked by changing all of the cells to d:mm:ss. Now I need to get it into Access in the same format. How do I do that?