create an hourly schedule?

caytib

New Member
Joined
Jun 25, 2002
Messages
25
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!
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
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!
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
Book1
DEFGHIJK
1StartDate&TimeBatchNumberVolProductScoreRateHoursperBatchEndDate&Time
29/30/0212:00DCLI-27N-0135.00DCL2150023.3310/1/0211:20
310/1/0211:20HCLL-27N-0110.00HCL215006.6710/1/0218:00
410/1/0218:00FCLL-27N-0270.00FCL2150046.6710/3/0216:40
510/3/0216:40FRHL-27N-0130.00FRH2150020.0010/4/0212:40
610/4/0212:40ANSC-27N-0230.00ANS1150020.0010/5/028:40
710/5/028:40NNCC-27N-01115.00NNC1150076.6710/8/0213:20
810/8/0213:20PYCC-27N-0235.00PYC1150023.3310/9/0212:40
910/9/0212:40NNCC-27N-0275.00NNC1150050.0010/11/0214:40
1010/11/0214:40ANSC-27N-0335.00ANS1150023.3310/12/0214:00
1110/12/0214:00FCLL-27N-0385.00FCL2150056.6710/14/0222:40
1210/14/0222:40JCHH-28N-0130.00JCH2150020.0010/15/0218:40
1310/15/0218:40DCLI-28N-0140.00DCL2150026.6710/16/0221:20
1410/16/0221:20FCLL-28N-0180.00FCL2150053.3310/19/022:40
1510/19/022:40HCLL-28N-0110.00HCL215006.6710/19/029:20
1610/19/029:20FRHL-28N-0125.00FRH2150016.6710/20/022:00
1710/20/022:00ANSD-28N-0130.00ANS1150020.0010/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.
 
Upvote 0
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
 
Upvote 0
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?
 
Upvote 0
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
 
Upvote 0
GOT IT!!!! :eek:))

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
 
Upvote 0

Forum statistics

Threads
1,218,538
Messages
6,143,078
Members
450,461
Latest member
Bosavon

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top