Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tracking overtime signups in 1/2 hour increments by day
In the Conditional Formatting setup for the cell in question (I used A1
for this example), set the dropdown to "Formula Is" and enter this formula as the condition: =A1="x" Then apply the desired format. If you don't mind an outside opinion, I prefer your first example above, which shows the 8:00 slot twice. That seems more intuitive, and may be helpful for your non-Excel friendly user. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
rounding up time to quarter hour increments | Excel Worksheet Functions | |||
rounding up time to quarter hour increments | Excel Worksheet Functions | |||
rounding up time to quarter hour increments | Excel Worksheet Functions | |||
Need help calculating overtime to date | Excel Worksheet Functions |