Condensing Data in an Excel Document

Hi,

i have a report from Zoom showing who attended the event we hosted, now the report by default show you every instance that a user disconnects/leaves and reconnects to the session hence some of them will show several entries.

We want to condense the data so it only show the user once, the time they logged in and logged off - so there will be some calculating involved of how many minutes they stayed on full

The report is in excel

Thanks