I have a strange issue occurring only with Excel 2010.
I have narrowed the problem down to strictly this version of excel and it doesn't happen on systems that have Excel 2007 or earlier.
I run a query against a database that includes DATE and TIME columns and return the results to MSquery.
Example: Date returns 2011-04-11 and Time retuns 05:24:00
When I return data to Excel 2011, I get the following under all the time columns: 0:00:00
It's not pulling the times from MSQuery.
My only current solution is to go back to office 2007 which is not what I'm looking for.
Help would be greatly appreciated!