Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I dont know if this can be done
Hey everyone First post. I'm in need of some help. I work for a smal company but we are growing and I handle scheduling along with my norma work. It takes a long time to write out everyones schedules so i've bee trying to creat an excel SSheet that can do something like this: EmpID Name Sunday Monday Tuesday ect ect. 11aa Brian 0-10,20-22 9-17 8-10,14-18 22bb Jim 4-8,12-20 17-21 9-17 That's what i'd like my data entry to look like. But i want the output sorted visually like so bear with me :) Code ------------------- 11aa Brian 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Monday X X X X X X X X X X X X Tuesday X X X X X X X (rest of the days) 22bb Jim 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Monday X X X X X X X X X X X X tuesday ------------------- This didn't come out very well basic idea is the X's should represent colored block instead of a white one in a time slot where the employe is scheduled to work. So basically i need to get excel to recognize 2-4,6-10 as 2am thru 4a and 6am thru 10am on monday then graphically display the information. I really hope this can be done, many many thanks in advance. Blendergu -- BlenderGu ----------------------------------------------------------------------- BlenderGuy's Profile: http://www.excelforum.com/member.php...fo&userid=1531 View this thread: http://www.excelforum.com/showthread.php?threadid=26946 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dont want #DIV/0!. | Excel Worksheet Functions | |||
I dont want #N/A! | Excel Discussion (Misc queries) | |||
Dont know if this is possible to do | Excel Discussion (Misc queries) | |||
Dont know if this is possible to do | Excel Discussion (Misc queries) | |||
Dont know what to use. | Excel Worksheet Functions |