Time Duration

[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

 

[MacDermott]

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

 

[Steve]

Thanks. Sure that would be fine. Could you tell me how to make a field
that holds that information?

 

[MacDermott]

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