the roster

gtho351

New Member
Joined
Aug 24, 2005
Messages
27
[HtmlMaker 2.42]



--------------------------------------------------------------------------------


Microsoft Excel - Master Roster Finished.xls ___Running: xl97 : OS = Windows 98

(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout

C3D3E3F3G3H3K4L4K5L5K6L6K7L7K8L8B9C9D9E9F9G9H9K9L9K10L10K11L11K12L12K13L13B14C14D14E14F14G14H14K14L14 =


A B C D E F G H I J K L
3 DATES 01/01/06 01/02/06 01/03/06 01/04/06 01/05/06 01/06/06 01/07/06 CSA HOURS Weekend
4 SHIFT MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY SATURDAY SUNDAY Marlene 29.00 0.00
5 Shift 1 Rob 0.00 8.50
6 Start 06:00 06:00 06:00 06:00 06:00 06:00 06:00 Glenn 22.50 5.00
7 Finish 14:00 13:00 13:00 13:00 13:00 13:00 14:00 Jason 24.50 2.00
8 Name Marlene Marlene Marlene Marlene Marilyn Marilyn John John 17.00 8.00
9 Total Hours 8.00 7.00 7.00 7.00 7.00 7.00 8.00 Skye 18.00 9
10 Marty 6.50 5.50
11 Start 2 13:30 12:30 12:30 12:30 12:30 12:30 13:30 Marilyn 19.00 7.00
12 Finish 18:30 17:00 18:30 18:30 16:30 17:30 22:30 0 0
13 Name Skye Skye Marilyn Marilyn Skye Glenn Skye 0 0
14 Total Hours 5.00 4.50 6.00 6.00 4.00 5.00 9.00 Training 0.00 0
Sheet1 (2)


[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.



--------------------------------------------------------------------------------


This free code was written by Colo and Ivan F Moala:[HtmlMaker 2.42] - 15th May 2003
Code mods by Ivan F Moala - 15th May 2003
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

wigi

Well-known Member
Joined
Jul 10, 2006
Messages
7,958
Office Version
  1. 365
Platform
  1. Windows
  2. Mobile
  3. Web
What do you want to do?
 

gtho351

New Member
Joined
Aug 24, 2005
Messages
27
Sorry about that mess

What i am trying to do is find a way to get this formula=SUM((C8:C33=Glenn)*OFFSET(Glenn,-3,0)) to automaticly happen at the moment I have to enter a cell referance in Glenn in the offset section of that formula
I have 3 worksheets I am trying to get to work together 1 is a Staff roster
2nd is a staff time sheet 3rd is a wages sheet. Time sheet and Wages sheet work fine the hard part is getting the Roster to transfr the staff start and finishing times to the Time sheet
Cheers
Bill
 

gtho351

New Member
Joined
Aug 24, 2005
Messages
27
Manager master Timesheets.xls
BCDEFGHIJKLMNO
6PermanentCasual
7DayDateStart TimeBreakFinish TimeAllowanceEmployee SignatureMonday - 12pm Sat HoursSat 12pm - Sunday HoursMonday - Friday HoursSat & Sun Hours
8WEEK 1UnpaidCrib
9MON20/02/0612:0012:000
10TUE21/02/0606:0012:306.5
11WED22/02/0606:0012:306.5
12THU23/02/0606:0012:306.5
13FRI24/02/0606:0012:307
14SAT25/02/0606:0012:306
Marilyn Bertram
 

Forum statistics

Threads
1,141,224
Messages
5,705,122
Members
421,378
Latest member
CarlosDuran

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