Time format - Thousandths of a second

[Trickyrla]

Hi guys - hope you can help

I am creating a simple swimming gala database (although it doesn't seem so simple now I've started!). In one of the tables I want to record competitors times in minutes, seconds and thousandths of a second. I also elsewhere need to be able to add similar times together. Can anyone tell me how I might be able to set up a custom time format for this please?

Many thanks

Tricky

 

[dk]

Hi Tricky,

The problem with standard date/time formats in Access is that they only store data to the nearest second. My advice to you would be to store the time as a Single data type and use seconds as the measure e.g 340.298 seconds. Any time you need to display the information you can easily do it with a simple calculation e.g.

Dim TimeTaken As Single
Dim MinsAndSeconds As String
MinsAndSeconds = IF(TimeTaken>60,INT(TimeTaken/60),0) &" Minutes " & MOD(TimeTaken,60) & " Seconds"

 

[Trickyrla]

Thanks Dan

Yep I thought I was going to have to "fudge it". Looks like I could have a little fun with input forms, queries and reports as well. I'll try your suggestion and see how it looks.

Thanks again

Tricky