Identifying Timecard Overlaps

trizahler

New Member
Joined
Oct 1, 2017
Messages
5
Hello, thank you in advance for any replies.

I am trying to piggyback off an older thread here to develop a spreadsheet formula tool to identify timecard overlaps.

https://www.mrexcel.com/forum/excel-questions/709968-calculate-amount-overlapping-time.html#post4932454

I can provide a google sheet link to my data if that is helpful.

https://docs.google.com/spreadsheets...it?usp=sharing

I am trying to compare shifts worked by home medical workers (PCAs) at different agencies attempting to find overlaps with the formula posted in this forum topic.

Column N ties Columns B, C,D, E together, but I do not know how to expand the formula in Column N to tie Columns H,I,J,K together as well.

The workers are attempting to work at two different organizations at the same time and be paid for it. I am attempting to identify the fraudulent times worked by identifying timecard overlaps.

Also Column Q is supposed to calculate a total number hours of overlap, but I cannot seem to get that formula to work.

Any advice or guidance would be most appreciated.

Thank You for Your Time!
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Forum statistics

Threads
1,223,901
Messages
6,175,277
Members
452,629
Latest member
SahilPolekar

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top