Web Development
I want to create a data base that can add up time but the time will be in hh:mm:ss.00 ie down to 100ths of a second.
How do I Custom Format the time cell as is possible in XL5.
by bristar
Access does not support hundredths of a second, nor does it add time easily. Excel can easily do this with the following time format:
[h]:mm:ss.000
The 0's at the end can extend as far as you would like to go. These will add up nicely for you inExcel -- if you need the information in Access, you may need to consider a string format field hooked up via a data link into Excel.
by timfox
MS Access cannot achieve 100ths of a second using any conventional time capturing methods.
If your time values are going to be uploaded or manually entered, then you could use a string field to store the values and write custom time addition functions to do the maths.
You can always connect your table datasets to Excel spreadsheets to link/upload data values.
If storing as a string, construct your own format for including the 100ths.
Cheers
TimFox
This discussion is closed to new replies.
Sort by Trending