Time with 2 decimal places

[Petra6]

I am trying to write a databse of swimming times, which require the format
mm:ss.00; e.g. 16:23.34 (16 Minutes 23 Seconds 34 One Hundredths of a second
). In Excel I can create my own format to reflect the this but I seem to be
struggling with Access. Can anyone advise?

 

[Rick Brandt]

I am trying to write a databse of swimming times, which require the
format mm:ss.00; e.g. 16:23.34 (16 Minutes 23 Seconds 34 One
Hundredths of a second ). In Excel I can create my own format to
reflect the this but I seem to be struggling with Access. Can anyone
advise?

Access DateTimes are for storing points in time, not amounts of time. In
addition, the resolution doesn't go below one second. For your purposes
just store the total number of seconds using a Currency field and then use
an expression for display in minutes/seconds.

For example your time would be stored as 983.034 seconds and the
expression...

Format(983.034\60,"0:") & CStr(983.034 mod 60) &
Format(983.034-fix(983.034),".000")

....will return 16:23.034