Time Format

[MaureenKLM]

Access 2002 DB -
Have a table to record running event times so the format should be something
like
n:ss.tt (nothing over 59 minutes). I need minutes, seconds and thousands
with the seconds and thousands being 2 digits each.

I am trying to format the field in design view of a table. I don't want
AM/PM and I want the time to display as entered -

Please advise how to format this field - THANKS

 

[John Vinson]

Access 2002 DB -
Have a table to record running event times so the format should be something
like
n:ss.tt (nothing over 59 minutes). I need minutes, seconds and thousands
with the seconds and thousands being 2 digits each.

I am trying to format the field in design view of a table. I don't want
AM/PM and I want the time to display as entered -

Please advise how to format this field - THANKS

You CANNOT use a Date/Time field for this purpose. That fieldtype is
best used for specific points in time rather than durations, and in
any case is limited to one second as its finest granularity.

I'd suggest storing the duration in a Double Float count of seconds -
e.g. 3:15.25 would be stored internally as 195.25. You can format it
for display with an expression like

[Racetime] \ 60 & Format([Racetime] - 60*([Racetime] \ 60), ":00.00")


John W. Vinson[MVP]