Write a VBA that collates total attendance duration for each user

Hello ajinkyabhosale777 and Welcome to Excel Forum.
This is a pivot table proposal that includes the Show Report Filter Pages option.
Here is a link to a tutorial that may help understand the option: https://www.excelcampus.com/pivot-ta....%20See%20More.
Steps:
1. Add a column (K) that converts the text times in column H to actual times using: =(LEFT(H2,3))/1440
2. [optional] Format the new column to time: [h]:mm;@
3. In the pivot table (Sheet2) pull Name to Filters area, Meeting name and Dummy attendee email to Rows area and the field for the new column (Attendance Duration 2) to the Values area.
4. Utilize the Show Report Filter Pages option as described in the tutorial to automatically produce the pages per name
Let us know if you have any questions.