I make a log sheet in MS Access where i want to calculate total time diff.?

Question

The fields are :- Name(Primary Key),Start_Time, End_Time and Total_Time

Answer 1

Do it in excel, if you wan to to do it in access you will need to do a query over the table with

select sum(end_time)-sum(start_time) as totaltimediff from table1

Answer 2

Create an Update Query in MS ACCESS

update tab set total_time=start_time-end_time;

Answer 3

Hi, you might find your answer here. If not, you will probably get an answer to your question in this forum. Good luck.

http://www.thescripts.com/forum/thread189487.html