OK - well the code I suggested only allows for one start and one end per day
This code will provide a time for each work period
Code:
SELECT Table1.job, (SELECT MAX(enddt) FROM Table1 T WHERE Job=Table1.Job AND enddt<Table1.enddt and datevalue(enddt)=datevalue(table1.enddt) ) AS Started, Table1.enddt, [enddt]-[started] AS workhrs
FROM Table1
WHERE ((((SELECT count(*) FROM Table1 T WHERE Job=Table1.Job AND enddt<Table1.enddt and datevalue(enddt)=datevalue(table1.enddt) ) Mod 2)<>0))
and if you just want the total for each day, wrap it in a group by query
Code:
SELECT C.job, DateValue([enddt]) AS WorkDay, Sum(C.workhrs) AS SumOfworkhrs
FROM (SELECT Table1.job, (SELECT MAX(enddt) FROM Table1 T WHERE Job=Table1.Job AND enddt<Table1.enddt and datevalue(enddt)=datevalue(table1.enddt) ) AS Started, Table1.enddt, [enddt]-[started] AS workhrs
FROM Table1
WHERE ((((SELECT count(*) FROM Table1 T WHERE Job=Table1.Job AND enddt<Table1.enddt and datevalue(enddt)=datevalue(table1.enddt) ) Mod 2)<>0))) AS C
GROUP BY C.job, DateValue([enddt])