Calculating times?

[gblack]

How can I get Access to calculate the difference of two times in Short Time format?

I have an unbound textbox with the start time xx:xx and a second textbox with the end time in xx:xx...

I don't know how to do it, but I want to have a third unbound text box = [textbox2] - [textbox1].

Anyone have any ideas?

 

[R. Hicks]

If the ending Time value will span past midnight ... you will have a problem due to you only entering a Time values.

If the Date and Time is entered you would not have the problem. You simply use the DateDiff() function to calculate the elapsed time.

If your total elapsed time will never span more that 24 hours .. go to the link below for a work around and more detailed info on this problem.

Using DateDiff .... StartTime-EndTime Results in a Negative Number

HTH
RDH