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.