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
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

wigi

Well-known Member
Joined
Jul 10, 2006
Messages
7,953
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
 

Watch MrExcel Video

Forum statistics

Threads
1,108,986
Messages
5,526,065
Members
409,685
Latest member
Davetom

This Week's Hot Topics

Top