=ARRAYFORMULA(IF(filter(A4:A,A4:A<>""),IF((B4:B>TIMEVALUE("10:00:00"))*(B4:B<TIMEVALUE("17:00:00")),"Yes","Not")))

I succeeded at making my time table to show whether it's collected during work time or not. But since I don't work during weekends, I  need it to show whether it's collected during normal weekday or during weekend. (I'm trying to find the average of the general response time for my company's inbound calls)

Can I please get a help on this?

In short, I need to make my last column show:

- For the data collected during workdays whether it was collected between 10:00am ~ 5:00pm (YES, NOT)
- and shows "weekend" for the data that were collected during weekend.

and here's [the sample spreadsheet](https://docs.google.com/spreadsheets/d/14X9zYMuU_0tJE43W8lHFO3F_yjA3qnVq1LhGLex1jqo/edit#gid=0).