Online event attendance data help

%3CLINGO-SUB%20id%3D%22lingo-sub-2756853%22%20slang%3D%22en-US%22%3EOnline%20event%20attendance%20data%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2756853%22%20slang%3D%22en-US%22%3EHi%20everyone%2C%20can%20someone%20help%20me%20out%3F%3CBR%20%2F%3EI%20have%20the%20following%20dataset%20with%20the%20date%20and%20time%20when%20different%20people%20joined%20and%20left%20an%20event.%20Some%20people%20joined%2C%20left%20and%20then%20rejoined%20various%20times.%3CBR%20%2F%3EI%20would%20like%20to%20calculate%20the%20attendance%20duration%20of%20each%20person.%3CBR%20%2F%3EThank%20you%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2756853%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2758968%22%20slang%3D%22en-US%22%3ERe%3A%20Online%20event%20attendance%20data%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2758968%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1157964%22%20target%3D%22_blank%22%3E%40Hrobino%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EInstead%20of%20using%20that%20oops%20image%2C%20your%20data%20set%20will%20be%20more%20meaningful%20if%20you%20replaced%20the%20names%20with%20Name01%2C%20Name02.....etc%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
Hi everyone, can someone help me out?
I have the following dataset with the date and time when different people joined and left an event. Some people joined, left and then rejoined various times.
I would like to calculate the attendance duration of each person.
Thank you
1 Reply

@Hrobino 

Instead of using that oops image, your data set will be more meaningful if you replaced the names with Name01, Name02.....etc