# usf

1. ### Error in Overlapping Time

Marcelo, please check the formula if it has some issue = SUM(IF(A\$2:A\$9999=A312,IF(1-((B312>C\$2:C\$9999)+(B\$2:B\$9999>C312)),IF(ROW(A\$2:A\$9999)>ROW(A312),IF(C\$2:C\$9999>C312,C312,C\$2:C\$9999)-IF(B\$2:B\$9999>B312,B\$2:B\$9999,B312))))) Result should be 1 hour instead of 17:37 hours...
2. ### Over lapping time calculation for same entries

I need the overlapping time in column D, for example, A2, A7 and A8 has keyword KUND (USF). If there is any common time between these three entries then we should mention it in column D <tbody> Name Start Time End Time Overlapping Time Kund (USF) Khuzdar 7:27:22 PM 8:27:22 PM...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back