Calculate Total Hours when Overlapping Occurs

G

garciapliz

Hello Excel Banter Community,
I have been searching over the internet and have come across valuabl
information to help with my question but I am at a loss. In m
spreadsheet I have put formulas in column O and P. In column O I a
checking the span and if it's true put a 0 and if it's false enter a
so that I could multiply this column to column N in which I have alread
calculated the total hours. However looking closer at the data I se
that this formula is not working as expected. So I went and found th
formula in column P to validate and as you see the TRUE/FALSE does no
align with the formula in column O. I am asking for your help i
calculating the total hours and be able to find the min date/hour an
max date/hour in which that overlap occurred so that I can eventuall
plot this by month

+-------------------------------------------------------------------
|Filename: Overlap Hours.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=914
+-------------------------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top