10/10/2019

This would seemingly be simple to do. I have a "Report Date"column with hundreds of rows of dates. I need a custom column that indicates with an "x" or a flag of some type if each row in the Report Date column contains the latest report date within the column itself. Not today's date but the...

I am trying to figure out how to build a macro to spot missing sequence and add in a new row when found. There should be 1440 data points in column A The date and time formatting goes as followed 10/10/2019 7:41 10/10/2019 7:42 10/10/2019 7:43 10/10/2019 7:44 10/10/2019 7:45 10/10/2019 7:46...

I need to add time punches leaving out over lapping times Columns A time of punch D Queue E Agent Name F action (clock in or clock out) J total time between clock in and out I need to add up the times in column J that match an agent name and times do not over lap <colgroup><col...