LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
rounding up time to quarter hour increments kdp145 Excel Worksheet Functions 5 March 15th 06 12:05 AM
rounding up time to quarter hour increments kdp145 Excel Worksheet Functions 1 March 14th 06 07:11 PM
rounding up time to quarter hour increments kdp145 Excel Worksheet Functions 0 March 14th 06 06:43 PM
Need help calculating overtime to date BVHis Excel Worksheet Functions 8 January 9th 06 05:59 PM


All times are GMT +1. The time now is 02:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"