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

  • 1
    Maybe this is a string field in Access rather than datetime? – Akina Feb 25 at 10:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.