Calculating Total Time

[CCIDBMNG]

I've tried researching this on the forum and on Help but I can't seem to find anything so if someone could help I would greatly appreciate it. I have a data-entry form that whenever someone opens/closes the form it puts a time/date stamp into another table along with the initials of who is data-entering. I want to be able to run a query to show me the total time the person was in the form. I only have one date field so I can't use the datedif function. Someone please help.

 

[mrabrams]

Anyway I look at this, it seems to me that you would have to add a field in your table.
Either another time stamp on form close or a field for the calculated elapsed time.

Check out the timer event.
You could probably start the timer on form load and stop the timer and calculate the difference on form close.

I could be wrong (wouldn't be the first time !)


Just a guess to get you started.

Michael

 

[CCIDBMNG]

I just added a second field so I could calculate the times with the datediff function. It gives me the minutes as a whole number is there any way i can get the exact number like how many minutes and seconds? I'm not very familiar with the datediff function.

 

[mrabrams]

I don't have my samples handy, but this link should set you in the right direction: http://support.microsoft.com/search/preview.aspx?scid=kb;en-us;Q210276