Calculate time taken to complete the task

[sindhuja]

Hi All,

Bit confused with my requirement. Any help on this will be helpful.
I have table ttracker (to calculate the start and end time of the task) and the auxtime (to calculate the breaks).

Now i need to combine both the tables and find the total time taken to complete the task (excluding breaks). Have attached the sample database for the reference.

Have used two queries to find the difference in time am not sure how to corelate both the entries...

-Sindhuja

[nepotist]

Hi,
What I found after looking in to your access file is that you are trying to calculate the hours with diff and break, where diff is in hours and break is in minutes. which results in a number that wouldnt make any sense