After Event

[Abarency]

I have a couple time inputs in my form. I want the form to compute the difference between two of the times and display the result. I coded the following

Please Login or Register  to view this content.

But I get the following results

TimeRec = 10:00:00 AM
TimeOn = 10:10:00 AM
TotalRespTime = 12:10:00 AM

Why??

[JieJenn]

post your database?

[Abarency]

For security reasons I can't.

[alansidman]

Copy your db to a new db. Delete all data in your tables. Populate a couple of records with dummy data. Run a compact and repair and then post. This is a normal procedure in forums when you have confidential data. It allows those with expert knowledge to understand your issue more clearly and supply a relevant answer. Without this information, we are throwing darts at a target blindfolded.