Elapsed time

[Bee]

My problem is this: I want to keep a record of the time
required to perform certain functions under varying
conditions. So I want Access to accept and display time
as minutes and seconds only. No matter what I try Access
reconverts the input information to time of day.
What can I do?

 

[Ken Snell]

If you want to store minutes and seconds only, you'll need to use numeric
fields to do that. Store the total number of seconds in a field, and then
you can always convert them to minutes and seconds for display.

If you want to store the beginning time for an event and the ending time for
an event, use date/time fields. Then use the DateDiff function to calculate
the elapsed time in seconds, and then display the results in minutes and
seconds.

 

[Bee]

I was afraid of that. However, it is a straight forward
way of looking at the data.
Thanks for your reply.