|
|
|
|
Joined: Oct 2003
Posts: 669
Veteran CEG\'er
|
OP
Veteran CEG\'er
Joined: Oct 2003
Posts: 669 |
I am still working on my scheduling issue, anyone online that I can email this thing too, I need to total up the number of hours each person works..
Thanks
CC
1999 Mystique Sport 2nd owner bought it in Sept 03
120000km 4 door, leather, loaded pics on cardomain, coatsy
|
|
|
|
|
Joined: Dec 2003
Posts: 674
Veteran CEG\'er
|
|
Veteran CEG\'er
Joined: Dec 2003
Posts: 674 |
=sum(startingCell:finishingCell)
|
|
|
|
|
Joined: Oct 2003
Posts: 669
Veteran CEG\'er
|
|
OP
Veteran CEG\'er
Joined: Oct 2003
Posts: 669 |
Ok, however I have each persons name down the left side, and then in each cell I have 0700-1500 or 1000-1730
for example..
How would I find the Sum with these?
1999 Mystique Sport 2nd owner bought it in Sept 03
120000km 4 door, leather, loaded pics on cardomain, coatsy
|
|
|
|
|
Joined: Nov 2004
Posts: 1,516
Hard-core CEG\'er
|
|
Hard-core CEG\'er
Joined: Nov 2004
Posts: 1,516 |
put starting time in one cell, end time in another, daily total(end-start) in a thrird cell and sum up the daily totals for a weekly total. I can email you an example if you would like.
Cameron
98 Black CSVT #2958
|
|
|
|
|
Joined: Oct 2003
Posts: 669
Veteran CEG\'er
|
|
OP
Veteran CEG\'er
Joined: Oct 2003
Posts: 669 |
I would appreciate that. Please send to koatsy1@yahoo.comI have 10 employees, an 5 shifts a day. 7-3 8-4 7-1 10-530 12-6 Thanks in advance,
1999 Mystique Sport 2nd owner bought it in Sept 03
120000km 4 door, leather, loaded pics on cardomain, coatsy
|
|
|
|
|
Joined: Nov 2004
Posts: 1,516
Hard-core CEG\'er
|
|
Hard-core CEG\'er
Joined: Nov 2004
Posts: 1,516 |
sent incase the email doesn't make it through the spam filter here is a link to the file: formula.xls
Cameron
98 Black CSVT #2958
|
|
|
|
|
Joined: Mar 2001
Posts: 7,431
Hard-core CEG'er
|
Hard-core CEG'er
Joined: Mar 2001
Posts: 7,431 |
Originally posted by SVTatGT:
put starting time in one cell, end time in another, daily total(end-start) in a thrird cell and sum up the daily totals for a weekly total. I can email you an example if you would like.
That only works if the employees don't work overnight. Otherwise Excel would be creating a negative amount of hours worked.
Edited because I didn't see the document you posted before writing my post - looks like Excel does indeed handle time nicely.
|
|
|
|
|
|
|
