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:
dim t as date
t=format(now,"hh:mm:ss")
Now I am writing the following line of code to find time diff but it gives me type mismatch error:

dim b as date
b=t-textbox1.value

Can anyone please figure it out.

Thanks
Aman