| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Staff rota, how can I make a letter represent a shift?
I am trying to set up a staff rota in Excel 2003. Can I enter letters to
represent not only the shifts but also the hours of the shift e.g. E = Early shift, 8 hours,L=Late shift,7.5 hrs,X=day off, that can then be added together with other shifts to check total hours worked?e.g would return total.. M T W Th F S Total VM L E L E E X 39 NJ E L E L E X 39 BH L L E L E X 38.5 Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| make a letter in a cell automatically equal a dollar amount | Excel Discussion (Misc queries) | |||
| What function can make cells shift up when they are blank? | Excel Worksheet Functions | |||
| Excel: How do I type a letter in a column and make a check mark a. | Excel Worksheet Functions | |||
| How can I make cell data automatically shift up when deleting | Excel Discussion (Misc queries) | |||
| How can I make cell data automatically shift up when deleting... | Excel Worksheet Functions | |||
Threaded Mode
