Elapsed time field

[Chris Warner]

I am trying to create a Training Log database for running and do not know how
to format the runnin gtimes. I want a field that can store elapsed time in
minutes:second, but do not know the format to use in the Table

 

[John W. Vinson]

On Sat, 27 Sep 2008 12:09:01 -0700, Chris Warner <Chris

I am trying to create a Training Log database for running and do not know how
to format the runnin gtimes. I want a field that can store elapsed time in
minutes:second, but do not know the format to use in the Table

I'd suggest stroring the running times (is this physically running around a
track, as opposed to say running a video? doesn't much matter) as a Long
Integer count of seconds. For example a running time of 4 minutes 15 seconds
would be stored as 255.

You can *display* this value as minutes:seconds with an expresson like

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

The advantage of storing seconds as a number is that the runtimes can easily
be sorted, averaged, summed and so on.