If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Athletic time calculations
We are setting up a db to track performance of athletes at track meets. The
first question we have is how would we store times in the following format, 11:22.33 (minutes:seconds.hundredth of seconds). And the second how would we calculate improvements in performance. |
#2
|
|||
|
|||
Athletic time calculations
My recommendation for the first would be to store the times as hundreds of
seconds in Long Integer fields. Your sample time (11:22.33) would be stored as 11*60*100 + 22*100 + 33 = 68233. Write functions to convert back and forth between the two. With your times stored like that, it should be pretty straightforward to calculate percentage improvement. Realistically, Access doesn't have a Time data type. While the Date data type can store times as well, it's really intended for timestamps (i.e.: specific date/time combinations), not elapsed times. As well, the Date data type isn't guaranteed to be accurate to hundreds of seconds. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Ryan" wrote in message ... We are setting up a db to track performance of athletes at track meets. The first question we have is how would we store times in the following format, 11:22.33 (minutes:seconds.hundredth of seconds). And the second how would we calculate improvements in performance. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Date, Time Calculations | Chuck216 | General Discussion | 1 | January 16th, 2006 09:18 PM |
time sheet calculations | emmcee | Worksheet Functions | 7 | August 20th, 2005 12:26 PM |
Time Calculations past midnight | DaveN | General Discussion | 2 | August 17th, 2005 10:36 PM |
Calendar Question | Josh | General Discussion | 7 | March 28th, 2005 11:19 PM |
Time Sheet calculations | John Tibbotts | Worksheet Functions | 1 | December 7th, 2003 05:21 AM |