comparing schedules

I have tried many formulas, they all fail somewhere, i am beyond my abilities now...
i need to compare the highlighted schedule to the other schedules, to give a % of hours worked together. does that make since? i am tying to see the number of hours and the % of time each employee spends with their managers. Now that im typing this, it would be nice to see that number of days they spend at work as well. Please let me know if you need more info.

thank you for your assistance

Dear ,


1.The highlighted names is Names of managers?
2.column R is the number of hours managers spend time with Staff?
3.and 899.45 is Total hours Abramovitz, Kelli worked with all his staff members?


please give some clearance over this.

Originally Posted by Md Aejaz

Dear ,


1.The highlighted names is Names of managers?
2.column R is the number of hours managers spend time with Staff?
3.and 899.45 is Total hours Abramovitz, Kelli worked with all his staff members?


please give some clearance over this.

Column R is only the number of hours each person is staffed,
the "manager" schedule is the highlighted schedule row's 15, 39, 66, ect.
i need to break this down per employee.

hi webejamn,

i hope your's below formula will work great.

'=IF(OR(Finish1<Start2,Start1>Finish2),0,MIN(Finish1,Finish2)-MAX(Start1,Start2))

but
why can't you get each team's data in separate sheets in same file?.. i guess, it would be very efficient if you create a template for this calculation.


Thanks very much..

-thiru

there is no reason i cant, i am just trying to get it to work, then i am goign to work on the layout and specifics
will this formula return a 0:00 value if there is no time schedule for one of the employees?

try this one...

THANK YOU.. thats perfect.

im not sure about your note though, why is your formula not as good?

actually when i started work on your question i didnt notice your formula. so i just created. later i realized your formula note.

did u notice, i missed the Max() part in my formula?.. thats the reason... Thank you...