time formatting

[jamwat]

i am importing excel time data into access. i want to display minutes, seconds and hundredths
in excel i use a mm:ss.00 format and this returns the correct value but access won't allow this format

when i use the ms format it actually returns a different value. a 1:07.893 time in excel returns 1:07.89 when i use mm:ss.00 and this gives me the correct value. when i use nn:.ss.ms it returns 1:08.18 for some reason. the format that works for me in excel dosn't play ball in access
any ideas

 

[missinglinq]

jamwat,

It is considered poor manners on this and every other forum I visit to post the same query more than once. You originally posed this question here at 2104 yesterday. If you're frustrated at the lack of a working answer, simply add a comment to your original posting. That will bring up back to the top of the list, and will give people who try to help you the other answers you've received.

The Missinglinq

There's ALWAYS more than one way to skin a cat!

 

[jamwat]

thanks for the tip, hope i didn't offend too many users