Easy One ....I think....

[DB]

I use excel to prepare duties at work.........basically i have 6
workbooks......monday thru to saturday....I have everyones start and finish
times, aswell as a breakdown of tea break...meal breaks etc......

Is there a way I can take the values of a particular cell.....say B 10 from
each page....this cell will always contain the start and finish
times.....i.e.......a text entry stating....08.50 - 17.35...

Is it possible to list someones basic hours on a page 7 of a workbook..all
it would have to do is repeat the text entry that is in B10 for one
person........C 10 for another etc etc....

It sounds simple but I cant quite get there.

Any help would be appreciated.....



Many Thanks

Dave

 

[Earl Kiosterud]

Dave,

Doable, but not particularly easy, as you have the data in 6 separate
workbooks. Consider making one table (one sheet) with all this data. Check
out "Data across multiple sheets" at
http://www.smokeylake.com/excel/excel_truths.htm. Yours is across multiple
workbooks, but the principle is the same.

Also, you've combined the start and stop times. You'll want to separate
them. You can do that with formulas in two new columns, then trash the old
stuff. Entering them will be easier, and your time calculations will be way
more straightforward.

 

[DB]

Thanks Earl......wow...Im totally stuck now tho.............

Dave

Anymore ideas anyone ???

 

[Pete_UK]

At the very least, combine all your worksheets together into one
workbook - open book1 (Monday) and the Tuesday book. Use Window |
Arrange | Horizontal to see both windows on screen together. Then
select the sheet tab for Tuesday and just drag it to the window for
Monday - the Tuesday window will disappear if that was the only sheet
in there. Open the book for Wednesday and drag its sheet tab over to
Monday's window. Keep doing this for the remaining workbooks, and you
will end up with one window with 6 sheet tabs in it - Use File | Save
As to give this composite file a different name, and none of your
original workbooks will have been changed.

Then you can start thinking about formulae linking these 6 sheets
together.

Hope this helps.

Pete

PS. Why start a new thread in .misc ?

 

[DB]

Cos I dont know what i'm doing,lol

You've sorted me Pete - Thanks

 

[Pete_UK]

Now you can start thinking about what Earl said - split your times into
two columns, so that instead of "08.50 - 17.35" in one column you have
08:50 in one column and 17:35 in another. These need to be in Excel
time format so that you can just subtract one from the other to get the
time difference (you'll probably want to subtract lunch and break times
as well).

I'm away for a few days now, but I'm sure others will be able to guide
you with further details.

Hope this helps.

Pete