break down hours between two times.

[daveyb60]

I have a spreadsheet with around 50 peoples work hours, two of the columns are time in and time out, the workers start at different times, some start at 02:00 till 10:00 some start 02:00 till 06:00 and some start 04:00 till 10:00 ect ect, i'm having trouble finding a formula to find the hours between two times for example all the hours between 02:00 and 03:00 buy using the two columns of time in and out and was wondering if anyone could help?
thankyou in advance

Dave

 

[gaz_chops]

Sorry i posted the wrong formula!

=SUMIFS($D$2:$D$8,$B$2:$B$8,">="&F12,$B$2:$B$8,"<="&G12)

D=Hours
B=Start Time
F=02:00:00
G=03:00:00

 

[daveyb60]

i have added a few more people to the list to get a better idea of what i'm trying to achieve with the table, so i have 11 people working and need to know how many man hours i have between the 1 hour slots, so the formula i put in counts the whole number, however George only starts at 2:45 so he only works 15 mins between 2 and 3 but its counted as an hour if you see what i mean, this is the same with Emma and the both Sams, Joe and Ant start at 02:30, so the 9 hours by the 02:00 - 03:00 so should be more like 5 hours, and thats the formula i need. not sure if thats any clearer :-s