Ask a new question

How to display hundredths of a second for sporting times and calculate the difference?

I am running Access 2010 and would like to store race times in mm:ss:hh format and calculate the difference.

I have a field [Entry Time] and [Race Time]

Any and all help would be appreciated
Answer
Answer

You will not be able to use an Access Date/Time value for this purpose: it's internally accurate to a few microseconds but the program only displays it to the nearest second.

I'd suggest storing the race time in a Double number of seconds; so a time of 4:09.22 would be stored as 249.22. You can display this in minutes and seconds using an expression like

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

To enter times in minutes and seconds, you'll need two unbound textboxes for minutes and seconds and some code to multiply the minutes by 60, add the seconds, and store the result in a bound control (which may be invisible if you prefer).

 

John W. Vinson/MVP

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated November 16, 2022 Views 86 Applies to: