Hi,
I have a query in access which contains some columns in a duration format hh:mm:ss, in access the format is correct and shows correctly. However when imported to Excel they all revert to 00:00:00 and I can't understand why as all the other formats text, number and % all work.
If there anything specific you need to do for time, either in the Excel sheet or prior in Access? Thank you in advance