Code for time difference between 2 fields as a time

[superhorse]

Hi, Im relatively new to access coding but I need to find a way of working out the [overall time] field automatically by subtracting the [time work ended] field by the [time work started] field which have a short time input mask. I'm having a bit of trouble working out the code for this, could someone please suggest some suitabel code to use? I know you shouldn't have spaces in table and field names but database already existed and I just need to create a few small tasks such as this one.

Cheers

 

[ajetrumpet]

Check out the DateDiff() function in the help menu. You will be able to get time differences in whatever interval you need using that function.