Formula help, Require to find Min and max of time referencing another cell

Hi All,

this may be a tricky one but I need assistance to

1. Populate an Unique Name (in Column D) from Column A (as there are multiple rows)
2. Find the Minimum Time in Column B referring to the Unique Name (Column D)
3. Find the Maximum Time in Column C referring to the Unique Name (Column D)

I have attached an example into the post below

ExampleSheet.xlsx

Thanks