difference in time calculations in ms access

[ianvanniekerk]

i have 2 textboxes on the form, one being the time the client entered the workshop (which is updated automatically when the ADD NEW button is clicked), the other being the time that the client left the shop (being entered manually)
What i would like to see, is how long the client has been in the workshop, with that time being calculated in another textbox (time left - time entered)

 

[GeekGirlau]

Create an unbound text box on your form, with the Control source set to

=DateDiff("n",[Time Entered],[Time Left])

This will give you the difference between the two times in minutes (or you can use "h" for hours).