Hi,
What I need to do next is basically, if you take the person below as an example, from the data below, there are three records for the 19th, so ignore 10:32a and combine 7:05p with 7:33p on the same row and do a duration calculation on another column. Also if the data is two row on the same date, like the 21st, combine the two data and do a calculation for the duration.
Name |EE # |State |First OutPunch |Second In Punch |Duration
John Smith |123456789 |GA |4/19/2010 10:32 |NULL |NULL
John Smith |123456789 |GA |4/19/2010 19:05 |NULL |NULL
John Smith |123456789 |GA |NULL |4/19/2010 19:33 |NULL
John Smith |123456789 |GA |4/21/2010 13:06 |NULL |NULL
John Smith |123456789 |GA |NULL |4/21/2010 13:38 |NULL
Would like the data to look like this:
Name |EE # |State |First OutPunch |Second In Punch |Duration
John Smith |123456789 |GA |4/19/2010 7:05 PM |4/19/2010 7:33 PM |28
John Smith |123456789 |GA |4/21/2010 1:06 PM |4/21/2010 1:38 PM |32
Thanks,
Ej