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 | ||||||||||||||||||||||||||
<tbody> </tbody> |
<colgroup><col><col></colgroup><tbody>
</tbody>
Any help will be greatly appreciated.
Thanks