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

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Dexter

Board Regular
Joined
Apr 3, 2002
Messages
71
Can you be more specific? Do you want this to calculate hours worked, paid?
 

caytib

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

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS
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

New Member
Joined
Jun 25, 2002
Messages
25

ADVERTISEMENT

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

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

plettieri

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS

ADVERTISEMENT

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

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

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS
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

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

Forum statistics

Threads
1,144,288
Messages
5,723,514
Members
422,502
Latest member
barakgahtan

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
Top