Run attendee reports

I need the attendee report for yesterday’s 10:00 AM training with the North Region sales team. Export a CSV that shows join and leave times, email addresses, and total duration for each participant. Before exporting, check for duplicate entries from reconnects and merge them so each person appears once with total time. Save the file as NorthRegion_Training_Attendees_2026-07-16.csv and send it to me and to Raj in HR by 4:00 PM today.

Before I send the attendee CSV to HR, make the attendance easy to verify: surface total time attended per person at the top, highlight anyone under 50% of the session, and list reconnects next to each name so a reviewer can tell if short durations were due to dropouts. Flag any entries without corporate emails and add a quick note about possible causes.

I just exported yesterday’s 10:00 AM attendee list and there are multiple rows for several people who rejoined. Raj in HR will treat each row as a separate absence unless I fix it. I’m worried merging could hide real partial-attendance issues. What’s the safest way to reconcile reconnect rows into a single record that preserves evidence of dropouts and is acceptable to HR?

Every week I spend 30–45 minutes cleaning attendee reports because reconnects create duplicate rows and HR wants a single total per person. It wastes time and causes follow-up emails. What one habit or change to our meeting setup or reporting process will stop this recurring cleanup and keep HR satisfied?