Count when someone works between the hours of 17:00 and 19:00 during the weekend

[Gratoc]

						Hi, I have a spreadsheet for working weekly on-call and I'm trying to create a formula for counting how many times work was carried out on a weekend between 17:00 and 19:00 hours. I tried something like this, which is not working: <code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: inherit;">=COUNTIFS(Oncall[Date],WEEKDAY(2>=6), Oncall[Time Start],">=17:00",Oncall[Time Start],"<=19:00") =SUMPRODUCT(--(WEEKDAY(Oncall[Date],2)>=6), --(Oncall[Time Start]>="17:00"),--(Oncall[Time Start]<="19:00"))</code>
						Example of the On-call spreadsheet below
						Date Time start Time finish 14/06/15 17:00 18:00 14/06/15 22:00 22:10 15/06/15 17:00 19:00 20/06/15 18:30 20:30 <tbody> </tbody>

<colgroup><col><col></colgroup><tbody>
</tbody>

Any help will be greatly appreciated.

Thanks

 

[Momentman]

Like this

=SUMPRODUCT((WEEKDAY(A2:A5,2)>=6)*(B2:B5>=TIME(17,0,0))*(C2:C5<=TIME(19,0,0)))