Time Field (Duration) (2002)

Topic

New Reply

I am a fairly novice Accesser.

I have an application where I want to track the duration of an event in minutes:seconds. I don’t care whether the colon appears (I can handle that), but I would like to validate correct entries and perform some simple math.

I tried to use short time (where I would pretend it was mm:ss rather than hh:mm), but that limits me to 24 “minutes”.

Is there any simple way to do this or am I going to need to code like hell?

Reply | Quote

Replies

In a new column in the query use
TimeDuration: DateDiff(“n”,[Field1], [Field2]) & ” : ” & (DateDiff(“s”,[Field1], [Field2])Mod 60)

Change Field1 and Field2 to you field names. This assumes the format for your time is hh:nn:ss
Paul

Reply | Quote

While that function will help with the math, what I am really looking to solve is how to store the basic durations. I am not storing a start date/time and an end date/time. I want to store the duration as minutes:seconds (e.g., 124:22 would be 124 minutes and 22 seconds). Math comes later. What is the best format for a column that would hold that type of data?

Reply | Quote

Without doing any calculations on the information, you would probably have to store is as TEXT. That is the only way I know of to store it as minutes:seconds. This would certainly affect how you calculate things down the road.
Paul

Reply | Quote

Paul’s right about the difficulties in storing the elapsed time in minutes:seconds. Even as text.

You might want to consider storing the elapsed time in total seconds, and let your math calculate the minutes:seconds later.

Tom

Reply | Quote

I thought this post was a good exchange of ideas on time problems and may be of some relevance.

Reply | Quote