Time Duration

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I'd like to be able to enter an elapsed time in a field with the format
MM:SS. My exercise bike records my workout duration from 1sec to 99:59
minutes. How can I create a field in my table formated in this manner. Id
like to be able to use these numbers in a calculation also. Like creating a
report with the sum of my weekly minutes.

TIA
Steve
 
Unfortunately, 99:59 is not in MM:SS format.
If you need to put numbers over 59 in the Minutes part, you'll have to work
it out as a custom function.
This can be done, but it's not a beginner level task.
Consider whether you could live with a format of H:MM:SS, where 99:59
minutes would become 1:39:59.

- Turtle
 
Thanks. Sure that would be fine. Could you tell me how to make a field
that holds that information?
 
In the table's Design View, set your field's Type to Date/Time.
You can set its Format to hh:nn:ss .

This should work fine for you -
let us know if you run into further difficulties.

HTH
- Turtle
 
Back
Top