Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-02-2011, 12:54 PM
ChefDan's Avatar
ChefDan ChefDan is offline New user needing help Windows 7 64bit New user needing help Office 2010 32bit
Novice
New user needing help
 
Join Date: Sep 2011
Posts: 2
ChefDan is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 09-05-2011, 02:08 AM
OTPM OTPM is offline New user needing help Windows 7 32bit New user needing help Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi ChefDan
Please see attached sample spreadsheet and see if this is what you are after.
Tony(OTPM)
Attached Files
File Type: xlsx Shift Rota's.xlsx (10.3 KB, 6 views)
Reply With Quote
  #3  
Old 09-05-2011, 06:52 AM
ChefDan's Avatar
ChefDan ChefDan is offline New user needing help Windows 7 64bit New user needing help Office 2010 32bit
Novice
New user needing help
 
Join Date: Sep 2011
Posts: 2
ChefDan is on a distinguished road
Default

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.
Attached Files
File Type: xlsx Timesheet.xlsx (12.1 KB, 6 views)
Reply With Quote
  #4  
Old 09-05-2011, 07:07 AM
OTPM OTPM is offline New user needing help Windows 7 32bit New user needing help Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi Dan
Don't forget to mark yourt thread as solved.
Tony(OTPM)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
User field+ jon_2011 Word 0 09-01-2011 07:35 AM
New user needing help Beginner needing help primmer3001 Office 1 08-22-2011 11:28 AM
New user needing help 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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:33 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft