00:00 Time format

[J. Shrimps Jr.]

Have time values generated by server log
in terms of minutes & seconds.
i.e. 32:15, 45:32. These are values of
how long user was logged onto server,
not time of day.

A field formated in Access 2000 Short Time
will not allow times in excess of
24 minutes, 59 seconds.
Is there another way to format a date/time
field so that I could track times in excess
of 24:59?

 

[Duane Hookom]

I'm fairly sure your time is being store hh:mm:ss not mm:ss. You need to
some how insert values like 00:32:15.

 

[Douglas J. Steele]

In addition to what Duane suggests, be aware that the Date/Time data type in
Access is only intended to be used for timestamps, not durations. Data is
stored in the field as an 8 byte floating point number, where the integer
part represents the date as the number of days relative to 30 Dec, 1899, and
the decimal part represents the time as a fraction of a day.

The standard advice for storing durations is to figure out the smallest
interval you need to store, then store the duration as a Long Integer in
that unit. In other words, if you want to be able to store seconds, store
the duration as number of seconds, so that 32:15 would be 1935, and 45:32
would be 2732. Write functions to translate from mm:ss to total seconds, and
from total seconds to mm:ss.