Trying to edit a formula, to don't sum duplicates

Hi everyone
I am trying to edit this formula to don't calculate duplicates, but I am not succeeding. The formula is:

Please Login or Register  to view this content.

I will try to explain better... The formula calculates the duration of some events from another sheet that are added automatically by a PowerAutomate script that adds to the Database Master sheet events from Google Calendar. We will take as an example the 10th of March. They are duplicates because they happen on the same day at the same time, as you can see from the screenshot below.

screenshot_20230322_122852.png

The formula I have created sums the duration of the events per each day so that I get the total in the cell of another sheet, 'Calcolo Giornaliero' what I am trying to achieve is that I want the formula only to calculate 1hour if the starting time is the same for that day.

screenshot_20230322_123707.png

Instead of 15:00 in cell E17, I expect 12:00 after removing the duplicates from the first screenshot. The same should reflect in the 'Calcolo Mensile' sheet where I get the total hours per each month, but also, in there duplicates are included. Do you have any ideas on how I can modify the formula to fix it?
Thanks in advance for any help provided

I'm not sure if this is in your version? but try Sum & Unique functions.......

Formula:

Please Login or Register  to view this content.

~ you have to put in your Range.

one option:

Formula:

Please Login or Register  to view this content.

Thank you, @queuesef, for taking the time to reply.

@XLent, your solution works perfectly. Do you have any idea how we could put something similar in the sheet 'Calcolo Mensile' where I get the total for each month? Instead of this formula?

Please Login or Register  to view this content.

Thanks a lot

if I've understood...same principle/logic

Formula:

Please Login or Register  to view this content.

This formula works perfectly, and I thank you for your time and effort.

Ultimately I realized that the calculation was still not giving me the desired result, so I came up with another formula:

in E17 of 'Calcolo Giornaliero':

Please Login or Register  to view this content.

This calculates the earliest time of the day's first event and the latest of the day's last event. In the example of the 10th of March, in the first screenshot of the thread, that would be from 09:30 to 20:00. Then the formula subtracts the time from 12:30 to 14:00, so my client will add another event to the calendar called 'pausa', and the formula finds that event and subtracts the duration of it from the total hours.

It will then be:

Please Login or Register  to view this content.

and that's exactly the amount of hours he works in the day

What I am struggling with now is adapting this formula to sum the total hours for the month in D4 of the 'Calcolo Mensile' sheet. I was hoping you could help. For some reason, I cannot attach images or the .xls file to this reply, so I will put screenshots for a clearer explanation and the updated file in a folder in my OneDrive.

That you find here:
https://1drv.ms/f/s!AnzCEK8poKX0ioQJ...SeUMQ?e=JYHwsa

Thanks again for your help