Using a time chart

  • Thread starter Thread starter fwday
  • Start date Start date
F

fwday

I am attaching an example of what I need. The green areas can also be
marked with "-" or "+" if needed. On sheet 2 you will see what I need
the results to be. I just want this to be done with a formula or a
macro.

I want to change what is on sheet one and have the results change on
sheet two.

File Attached: http://www.excelforum.com/attachment.php?postid=319230 (cashier schedules.xls)
 
since you are posting to a newsgroup, it might be noteworthy to know that
your link doesn't work outside the excelforum which is where many of the
answers would come from. Try explaining your problem fully in your email
and perhaps you will get some help. Otherwise, you might as well keep you
question in the excel forum.
 
Thank you Tom for the info.
I have tryed 4 times to explan what I am talking about and haven't had
any luck. Could you help
 
It looks like they have corrected it and the link works.

in B3 on sheet2 put in this formula

=Sheet1!$B$1+((SMALL(IF(Sheet1!$C2:$BV2<>"",COLUMN($C2:$BV2)),1)-2)*15)/(24*
60)
Enter it with Ctrl+Shift+Enter rather than just enter because it is an array
formula. If you get a #Value result, you didn't successfully enter it with
ctrl+shift+Enter.

In b4 on sheet2 put in this formula

=Sheet1!$B$1+((LARGE(IF(Sheet1!$C2:$BV2<>"",COLUMN($C2:$BV2)),1)-2)*15)/(24*
60)

Again, enter with Ctrl+shift+enter
 
Thank you for the info on making a cell fixed number to a input. It
worked.

On the issue of this time chart. I tryed the formula you gave me above
and it gave me a #NAME? error. Maybe I am going about this wrong.
 
It was copied right out of your sheet where it was working. Don't know
what to tell you.
 
I was thinking, mybe I need to put the times in first and have it make
up a chart that would look like the sheet one. Is that possible. And
if it is possible then is there a way to have excel recignize 1500 as
15:00. I just dont' know how to get the chart to look how I want it
to.
 
Tom,
Would you be able to send me a copy of the worksheet you used so that I
can break it down?
 
It doesn't appear your email address is valid, so I woudn't know how to send
it to you.

If you sent me your email address, then I can open you link again and paste
in the formulas and send it to you. My email address is valid.
 
Thanks
(e-mail address removed)
or
(e-mail address removed)
or
(e-mail address removed)

Go from top to bottom.
 
Back
Top