Data entry timing

[belsha]

In the thread "timing an event " it was discussed how to time how long a person played snooker and figure their total time. My question is if I have a form and want to start a timer when the person begins to enter and end it when they exit the form, then send the record number and time spent entering it to a table, how would I code that? Thanks!

 

[llkhoutx]

One simple way is noting the time when the form is opened (executing the NOW() function on the form OnOpen event or (record) OnCurrent event) and when a record updated (event OnAfterUpdate), and subtracting the two. Be careful of date rollover, that is, going from one day to the other.