availability sheet

Hi all

i have been giving the task of updating staff availability for work, the sheet that we currently work from is a bit confusing

white cellls = available for work
grey cels = not available
dots in cell = jobs allocated

how can i re arrange this so it clearer, i want to be able to have the day broken down into hours from 7am to 8pm.


any ideas

How much can it be changed ?

I'm open to anything that will improve it

Ok, I'll whip something up

Apologies, I didn't realise what the time was so this is a bit rushed, but here's an idea of what you could do.

It might be more in-depth that you need, or you might want to keep all the dates together in a continuous list etc. so you could just transpose what I've done and join each day together. It all depends on how you're going to work it.