Minus Time from Time VBA

[Qmustard]

Hi all,

Hoping this is an easy problem to fix!

I have the following in my <acronym title="visual basic for applications">VBA on the two seperate Userforms</acronym>:

Userform1.Time.Caption = Format(Now, "hh:mm:ss AMPM")

Userform2.Endtime.Caption = Format(Now, "hh:mm:ss AMPM")

Is it at all possible to subtract one from the other in <acronym title="visual basic for applications">VBA</acronym> to get the difference?

I've tried:

difference.caption = endtime.caption - time.caption

But it just errors on me, telling me its TYPE MISMATCH.

I'm basically looking for a quick way to see what time is on the first userform the user uses and then the time on the last form they use, to work out exactly how long it has taken them to get from one to the other.

 

[FormR]

Hi, you could try something like this:

difference.Caption = Format(TimeValue(EndTime.Caption) - TimeValue(Time.Caption), "hh:mm:ss")