Angelina Lee, Punch In, 12:54pm, 5/5/2020, , , ,
Angelina Lee, Punch Out, 5:57pm, 5/5/2020, , 5.00, ,
Angelina Lee, Punch In, 11:56am, 5/7/2020, , , ,
Angelina Lee, Punch Out, 4:57pm, 5/7/2020, , 5.00, ,
Angelina Lee, Punch In, 8:55am, 5/9/2020, , , ,
Angelina Lee, Punch Out, 3:54pm, 5/9/2020, , 7.00, ,
Angelina Lee, Punch In, 9:54am, 5/10/2020, , ,0 ,
Angelina Lee, Punch Out, 3:57pm, 5/10/2020, , 6.00, 0,
Angelina Lee,0 , , , , ,23.00, ,
Angelina Lee,0 , , , , ,23.00, ,
Angelina Lee,0 , , , , ,23.00, ,
Annette Cummings, Punch In, 4:52am, 5/4/2020, , , ,
Annette Cummings, Punch Out, 11:52am, 5/4/2020, , 7.00, ,
Annette Cummings, Punch In, 8:57am, 5/8/2020, , , ,
Annette Cummings, Punch Out, 3:03pm, 5/8/2020, , 6.00, ,
Annette Cummings, Punch In, 4:48am, 5/10/2020, , ,0 ,
Annette Cummings, Punch Out, 11:21am, 5/10/2020, , 6.50, 0,
Annette Cummings,0 , , , , ,19.50, ,
Annette Cummings,0 , , , , ,19.50, ,
Annette Cummings,0 , , , , ,19.50, ,
Cindy Albers, Punch In, 4:46am, 5/5/2020, , , ,
Cindy Albers, Punch Out, 11:48am, 5/5/2020, , 7.00, ,
Cindy Albers, Punch In, 4:47am, 5/7/2020, , , ,
Cindy Albers, Punch Out, 12:02pm, 5/7/2020, , 7.25, ,
Cindy Albers, Punch In, 4:45am, 5/8/2020, , ,0 ,
Cindy Albers, Punch Out, 11:43am, 5/8/2020, , 7.00, 0,
Cindy Albers,0 , , , , ,21.25, ,
Cindy Albers,0 , , , , ,21.25, ,
Cindy Albers,0 , , , , ,21.25, ,
I have the above file in a csv and need to match a specific date (i.e. holiday) and if it exist I need to know the hours worked that day and take that number times 5 and add it to the total at the the end of the name.
i.e. Cindy Albers on 05/05/2020 worked 7.00 hours and that is a holiday so 7.00 times .5 equals 3.5 added to her total at the bottom of 21.25 would equal 24.75.
After that is complete we need to just update the file with the new totals.