How can i calculate with Time?

I want zu Calculate the Time between 2 Timestamps, which are entered in textboxes..

enter image description here

CodePudding user response：

Use the DateDiff() function to specify the date/time values and the unit that you want the result returned in.

CodePudding user response：

No button needed; just use as ControlSource for the third textbox:

=CDate([Time2]-[Time1])

Then set the Format property of that textbox to a time format, for example:

h:nn