Help to write a VBA that collates total attendance duration for each user

Question

Could you please help write a VBA that collates total attendance duration for each user? I?d like it to output to a different sheet within the workbook. The sheet should have:
Meeting Name
Name
Attendee Email
Attendance Duration

We will use this repeatedly. Please provide a solution for reusability.
Attached is the sheet-

Answer 1

hi! Ajinkya Bhosale

meetingminuts.pdf
It may have already been resolved, but

calculation settings.

①Select column B:C, column F:G,

②③④User defined

⑤ yyyy-mm-dd hh:mm:ss　　Enter and "OK"

⑥ Select column H,

⑦⑧ User defined

⑨ [mm] "mins"　　　Enter and "OK"

⑩ Cell H2

= G2-F2　　　Autofill ↓Copy

Copy required columns to new sheet

"Meeting Name" "Name"

　Attendance Duration

⑪ Cell H2　

=SUMIFS(Sheet1!H:H,Sheet1!A:A,A2,Sheet1!D:D,D2)

　　　Autofill ↓Copy

Copy required columns to new sheet

"Name"

　Attendance Duration

⑪ Cell H2　

=SUMIF(Sheet1!D:D,D2,Sheet1!H:H)

　　　Autofill ↓Copy