I'm capturing the daily time employees spend on a multiple tasks for
billing. Can someone help me figure out how to confirm that the time
entered by each person daily follows two rules:
(1) no overlaps in time
(2) no gaps in time
good daily entry:
starttime-endtime
8:00 - 8:15 (task 1)
8:15 - 8:45 (task 2)
8:45 - 9:30 (task 3)
bad daily entry:
starttime-endtime
8:00 - 8:15 (task 1)
8:30 - 9:30 (task 2) (bad because of time gap)
9:15 - 10:15 (task 3) (bad because of time overlap)
I'm guessing I can start with a daily query for each employee and
process the data from the query.
I have no idea where to start looking for a function (or save the
function) that looks at one day's data to compare starttime = previous
endtime....
Can someone help please?
Thanks,
Debi