I have multiple service start and stop times crossing over from one day to the next as they are 3rd shifts. I want to qry this data in access to read as below.
I have attached the data I have in an access table. The employee clocks in and out for each svc provided to each location. I want it to show in one line item per employee per shift as I have listed below and I have also placed in the spreadsheet. Many times this is a cross over midnight into the following day. Along with this it is an ending of a shift in the AM of one day and the start of a shift in the same day but in the PM Hr. this is what I am trying to accomplish in Access database: Only thing I can think is Min Max times per AM per PM????? Pls help
Employee St Dt End DT Start Time End Time Hrs Wrkd
Joe 20101108 20101109 10:10:19 PM 2:39:31 AM 4.23
Katie 20101108 20101109 7:05:24 PM 12:10:30 AM 4.91
Joe 20101109 20101110 8:14:19 PM 1:36:06 AM 5.22