Results 1 to 15 of 16

20120114, 18:00 #1
 Join Date
 Jan 2012
 Posts
 2
 Thanks
 0
 Thanked 0 Times in 0 Posts
help with work schedule spread sheet
I am trying to design a spread sheet that calculates my hours worked. I am not sure how to get
this started. I work a 14 day pay cycle and I work a 24 hour shift. If the payperiod ends on a Friday
I get paid 16 hours that day and then my next pay period starts with left over 8 hours.
Here is my January work schedule. December 31 is the first day to start it.
1,3,10,12,14,16,21,23,25,27
So the first pay period would be a 96 hour pay period. 31 Dec13 Jan
Any advice and examples would be appreciated. Please send example attachments.
Thanks,
Dale

20120114, 18:24 #2
 Join Date
 Mar 2004
 Location
 Manning, South Carolina
 Posts
 9,433
 Thanks
 371
 Thanked 1,456 Times in 1,325 Posts
Dale,
Welcome to the lounge as a poster.
I'd advise you to immediately remove your account and start a new one. You should never post your email address in the open, you're just asking for spam big time.
As to your question exactly what do you want the worksheet to do. On a 14 day cycle your pay period should always end on the same day so I'm just not sure what you're after. Please enlighten us.May the Forces of good computing be with you!
RG
PowerShell & VBA Rule!
My Systems: Desktop Specs
Laptop Specs

20120114, 19:35 #3
 Join Date
 Jan 2012
 Posts
 2
 Thanks
 0
 Thanked 0 Times in 0 Posts
How do I remove an account?

20120114, 19:41 #4
 Join Date
 Oct 2007
 Location
 Johnson City, Tennessee, USA
 Posts
 3,202
 Thanks
 37
 Thanked 215 Times in 202 Posts

20120114, 22:55 #5
 Join Date
 Jan 2012
 Posts
 8
 Thanks
 0
 Thanked 0 Times in 0 Posts
I am trying to figure out how to design a spread sheet where I can put in the days I work per month and have it calculate out my different pay periods. I have 96,120,136,104 hour pay periods. I am trying to figure out how I can just put the days I work for the month in it and have it calculate what kind of pay period I will have.
I work a 14 day pay cycle and I work a 24 hour shift. If the payperiod ends on a Friday
I get paid 16 hours that day and then my next pay period starts with left over 8 hours.
Here is my January work schedule. December 31 is the first day to start it.
1,3,10,12,14,16,21,23,25,27
So the first pay period would be a 96 hour pay period. 31 Dec13 Jan
Any advice and examples would be appreciated. Please send example attachments.
Thanks,
DaleLast edited by Lounge2012; 20120114 at 23:36.

20120114, 23:31 #6
 Join Date
 Jan 2012
 Posts
 8
 Thanks
 0
 Thanked 0 Times in 0 Posts
Example of what I am looking for
Let me know what you think.
example.xls

20120115, 10:00 #7
 Join Date
 Mar 2004
 Location
 Manning, South Carolina
 Posts
 9,433
 Thanks
 371
 Thanked 1,456 Times in 1,325 Posts
Dale,
If I understand your requirements, this should do the trick. You can just copy down the sheet 2 rows at a time and all the formulas should adjust. Just clear out the day x's and x the proper days. The main formula is =(COUNTA(B4:N4)*24)+IF(ISBLANK(N4),0,16)+IF(ISBLAN K(N2),0,8)May the Forces of good computing be with you!
RG
PowerShell & VBA Rule!
My Systems: Desktop Specs
Laptop Specs

20120115, 12:46 #8
 Join Date
 Jan 2012
 Posts
 8
 Thanks
 0
 Thanked 0 Times in 0 Posts
It works great thanks a bunch! Does excell have a way to populate the Dates automatically?

20120115, 12:56 #9
 Join Date
 Jan 2012
 Posts
 8
 Thanks
 0
 Thanked 0 Times in 0 Posts
Thanks sorry it does it for me as you had intended thank you so very much for your help and formula design!
Dale

20120115, 13:12 #10
 Join Date
 Jan 2012
 Posts
 8
 Thanks
 0
 Thanked 0 Times in 0 Posts
When I get to October this happens and I am not sure why.October.JPG

20120115, 14:10 #11
 Join Date
 Jan 2012
 Posts
 8
 Thanks
 0
 Thanked 0 Times in 0 Posts
On Row 12 it miscalculates for some reason and I can not find out why. 24 hours worked x 4 = 96 + 16 hours for Friday = 112. The 8 hours carried over to the next one fine.
If you have any ideas please let me know.
Thanks,
Daleerror calculating.JPG

20120115, 15:55 #12
 Join Date
 Mar 2004
 Location
 Manning, South Carolina
 Posts
 9,433
 Thanks
 371
 Thanked 1,456 Times in 1,325 Posts
Dale,
The hashes (####) are just telling you need to widen the column width. I can't tell about the calculations w/o the worksheet. Are you sure you copied the formulas correctly?May the Forces of good computing be with you!
RG
PowerShell & VBA Rule!
My Systems: Desktop Specs
Laptop Specs

20120116, 15:16 #13
 Join Date
 Jan 2012
 Posts
 8
 Thanks
 0
 Thanked 0 Times in 0 Posts
Not calculating right
I have attached the file like I should have done in the first place PayPeriodCalc1. broken.xlsx
Thanks a ton for all the help!Last edited by Lounge2012; 20120116 at 15:26.

20120116, 17:05 #14
 Join Date
 Mar 2004
 Location
 Manning, South Carolina
 Posts
 9,433
 Thanks
 371
 Thanked 1,456 Times in 1,325 Posts
Dale,
Somehow the formula, probably through a drag & drop, was adjusted one cell to the right, e.g. B:N vs A:M! Here's the right one along with the workbook setup and fixed.
=((COUNTA(A4:M4)*24)+IF(ISBLANK(N4),0,16))+IF(ISBL ANK(N2),0,8)May the Forces of good computing be with you!
RG
PowerShell & VBA Rule!
My Systems: Desktop Specs
Laptop Specs

20120117, 00:49 #15
 Join Date
 Jan 2012
 Posts
 8
 Thanks
 0
 Thanked 0 Times in 0 Posts
It works outstanding thanks a ton for all your help