Macro to Compute Info if Cell is Red

I have a spreadsheet (Attached) that tracks a schedule of when certain games are being played each day. I am wondering if there is a way that the open spots (highlighted in Red) could be computed into a sheet that will show me the day and time of all the open "red" cells. So for example in that attached file, the Sunday open times would compute into: Sunday, Jan. 22: 8pm, 10pm, 11pm and so forth.
Any help or direction would be appreciated.
Thanks

Nathan