Elapsed time field

  • Thread starter Thread starter Chris Warner
  • Start date Start date
C

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
 
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
Click to expand...

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.
 
Back
Top