create an hourly schedule?

[caytib]

i need to create a schedule that allows for hourly entries for two weeks. any body got a download or know of a good example?

thanks!

 

[Dexter]

Can you be more specific? Do you want this to calculate hours worked, paid?

 

[caytib]

no, i've got 2+ pipelines and i'd like to see the schedules for each laid out side by side for each day for two weeks. I've got a start date/time and end date/time and a product for each batch in each pipeline. I'd like it to look at worksheet1 say 'oh, it starts at x date and y time with this product so x,y cell gets colored orange. i've tried a couple of things but can't get it to run right....does that help? or make it more confusing? thanks!

 

[plettieri]

It sounds like you are looking for a scheduler rather than a time sheet...care to show what data you are working with and the expected outcome you want to see.....let us worry about the formulars....

You can utilize the "Download Colo's cool utility for displaying your Excel Worksheet on the board"......as seen below this message text box.....

pll

 

[caytib]

the thing's too big to post (even when i cut it down) got e-mail? thanks
This message was edited by caytib on 2002-10-10 14:31

 

[caytib]

Book1
	D	E	F	G	H	I	J	K
1	StartDate&Time	BatchNumber	Vol	Product	Score	Rate	HoursperBatch	EndDate&Time
2	9/30/0212:00	DCLI-27N-01	35.00	DCL	2	1500	23.33	10/1/0211:20
3	10/1/0211:20	HCLL-27N-01	10.00	HCL	2	1500	6.67	10/1/0218:00
4	10/1/0218:00	FCLL-27N-02	70.00	FCL	2	1500	46.67	10/3/0216:40
5	10/3/0216:40	FRHL-27N-01	30.00	FRH	2	1500	20.00	10/4/0212:40
6	10/4/0212:40	ANSC-27N-02	30.00	ANS	1	1500	20.00	10/5/028:40
7	10/5/028:40	NNCC-27N-01	115.00	NNC	1	1500	76.67	10/8/0213:20
8	10/8/0213:20	PYCC-27N-02	35.00	PYC	1	1500	23.33	10/9/0212:40
9	10/9/0212:40	NNCC-27N-02	75.00	NNC	1	1500	50.00	10/11/0214:40
10	10/11/0214:40	ANSC-27N-03	35.00	ANS	1	1500	23.33	10/12/0214:00
11	10/12/0214:00	FCLL-27N-03	85.00	FCL	2	1500	56.67	10/14/0222:40
12	10/14/0222:40	JCHH-28N-01	30.00	JCH	2	1500	20.00	10/15/0218:40
13	10/15/0218:40	DCLI-28N-01	40.00	DCL	2	1500	26.67	10/16/0221:20
14	10/16/0221:20	FCLL-28N-01	80.00	FCL	2	1500	53.33	10/19/022:40
15	10/19/022:40	HCLL-28N-01	10.00	HCL	2	1500	6.67	10/19/029:20
16	10/19/029:20	FRHL-28N-01	25.00	FRH	2	1500	16.67	10/20/022:00
17	10/20/022:00	ANSD-28N-01	30.00	ANS	1	1500	20.00	10/20/0222:00
APLNSummaryRept

got it! (some of it any way) here's the data i'd pull off of....i'd have another sheet with dates across the top and times down the side.

 

[plettieri]

It sounds like you want to conditional format (color them orange) to a range of cells....is that correct? Try format | Conditional formatting | then select the parameters fo the conditioning.....Am I missing something...? Do you want to do any totals, summaries of sorts?

pll

 

[caytib]

i've got 10 of these sheets to show on the calendar....

no summaries or anything, the schedule sheet will, in effect, be the summary. can you do a conditional format using a cell on another worksheet?

 

[plettieri]

Sorry, don't know the answer....it would seem possible as you can use a formular in the conditioning process by I am not familar with that...if not, VBA code people could take a crack at it.....

pll

 

[caytib]

GOT IT!!!! ))

silly me, i confused the computer. backtracked thru the small amount of code i'd done for the macro and found the prob. Anyone wants to see, e-mail me...i'll have the thing finished up this weekend. Thanks for your help, guys!

caytib@hotmail.com put excel in your subject line if you would please...thanks!
This message was edited by caytib on 2002-10-10 16:42