Find time difference

Hi folks

I want to find the time difference using vba. when the form is intialized then the starttime gets stored in textbox1 as follows:

textbox1.value=format(now,"hh:mm:ss")

The finish time is calculated when the enter button is clicked and is stored in variable t as follows:

Please Login or Register  to view this content.

Now I am writing the following line of code to find time diff but it gives me type mismatch error:

Please Login or Register  to view this content.

Can anyone please figure it out.

Thanks
Aman

Try to put this code at form initialization:

Please Login or Register  to view this content.

then use this code at enter button click:

Please Login or Register  to view this content.

and then to calculate difference you can use:

Please Login or Register  to view this content.

Regards,
Antonio

Look at datediff (VBEditor, F1)

Thanks a lot Antonio. It works absolutely fine.