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!
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!