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

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
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
 
Upvote 0

Forum statistics

Threads
1,218,695
Messages
6,143,951
Members
450,517
Latest member
Rovex

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
Back
Top