View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stephanie
 
Posts: n/a
Default Tracking overtime signups in 1/2 hour increments by day

I need to set up a spreadsheet which allows the user to check off the fact
the someone has signed up for a overtime slot on Monday at 8:00 am but
allows the remaining slots to display. I am considering a spread sheet that
looks as follows:

8:00 8:00 (indicating 2 slots )
Monday
Tuesday

or rather
8:00
Monday 2 slots But how do you subtract the number who has taken the .

This spreadsheet will go to a user who is not friendly with excel. So it
has to be something easy to use.

How would conditional formatting be used to accept an "x" as a value? If
this is too much for the forum. Is their a information somewhere on
spreadsheet design?
--
Stephanie