time in minutes and seconds only?

  • Thread starter Firefighter Time Trial
  • Start date
F

Firefighter Time Trial

I am trying to keep track of times from a time trial event. Every time I try
to enter 4:46 as 4 minutes and 46 seconds Access automatically records it as
4:46 am.. is there away to fix this?
 
J

John Vinson

I am trying to keep track of times from a time trial event. Every time I try
to enter 4:46 as 4 minutes and 46 seconds Access automatically records it as
4:46 am.. is there away to fix this?
Click to expand...

An Access Date/Time value is actually not suitable for storing
durations. It's stored internally as a Double Float count of days and
fractions of a day since midnight, December 30, 1899; as such, any
date/time value corresponds to an exact point in time.

It may be better to store the times in a Long Integer count of
seconds, or a Double if you want fractions of a second. (Note that
Date/Time values do not support fractional seconds!) You can format
the value for display with an expression like

[RunTime] \ 60 & Format([RunTime] MOD 60, ":00")

For data entry, you can use two unbound textboxes for minutes and
seconds, with AfterUpdate code to push the total seconds into a bound
control.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top