#1
|
||||
|
||||
New user needing help
Hi All,
I'm new to using Excel & would like some help. I'm a chef & what I would like to do is use excel to do my rotas for work. I've seen it done elsewhere but I don't know how they did it. What I would like to do is when entering a shift eg E or Early have excel turn that word into a number eg 8 so I can add up the hours in the last box of the row. However I don't want to see 8 in the cell, so when I print the rota it still says E or Early. Also how can you change the colour of the cell to show days off eg when I enter rest the cell turns blue & if I put Holiday it turns red etc. Thank you in adavance for your help Chef Dan. |
#2
|
|||
|
|||
Hi ChefDan
Please see attached sample spreadsheet and see if this is what you are after. Tony(OTPM) |
#3
|
||||
|
||||
Hi, thanks for your reply, I also posted on the microsoft forums & with the help I got there was able to make the rota I've attached.
Dan. |
#4
|
|||
|
|||
Hi Dan
Don't forget to mark yourt thread as solved. Tony(OTPM) |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
User field+ | jon_2011 | Word | 0 | 09-01-2011 07:35 AM |
Beginner needing help | primmer3001 | Office | 1 | 08-22-2011 11:28 AM |
Powerpoint 2003 InsertFromFile without needing index | twnty2 | PowerPoint | 1 | 05-25-2011 10:11 PM |
HELP For New USER | ryalls3857 | Outlook | 0 | 09-29-2010 10:33 AM |
User seeing other user's color categories | MTFysherman | Outlook | 0 | 11-13-2008 04:36 PM |