General discussion

Locked

MS ACCESS TABLE CUSTOM TIME FORMAT

By Maurie Fuller ·
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.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
Thread display: Collapse - | Expand +

All Comments

Collapse -

MS ACCESS TABLE CUSTOM TIME FORMAT

by Bristar In reply to MS ACCESS TABLE CUSTOM TI ...

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.

Collapse -

MS ACCESS TABLE CUSTOM TIME FORMAT

by Maurie Fuller In reply to MS ACCESS TABLE CUSTOM TI ...

Poster rated this answer

Collapse -

by timfox In reply to MS ACCESS TABLE CUSTOM TI ...

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

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums