Formatting times taken from webpages
Posted by Frode Klow on December 12, 2001 4:50 PM
I've used web query to import a table of times into Excel. The times are written like this: 0:29, 1:20, 4:36, etc... where the number before the colon is minutes, and the number after is seconds. My problem is that when Excel reads this, it recognizes the number before the colon as hours and the number after as minutes. I've tried formatting the cells before importing the numbers, I've tried using all kinds of formats after, so what am I doing wrong?
Can anyone help, please?