1. ## 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 Dec-13 Jan

Thanks,
Dale

2. Dale,

Welcome to the lounge as a poster.

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.

3. How do I remove an account?

4. Originally Posted by lawyerdp.
How do I remove an account?
Log Off ....I'm on it Regards Fred

5. 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 Dec-13 Jan

Thanks,
Dale

6. ## Example of what I am looking for

Let me know what you think.

example.xls

7. 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)

8. It works great thanks a bunch! Does excell have a way to populate the Dates automatically?

9. Thanks sorry it does it for me as you had intended thank you so very much for your help and formula design!

Dale

10. When I get to October this happens and I am not sure why.October.JPG

11. 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

12. 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?

13. ## 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!

14. 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)

15. It works outstanding thanks a ton for all your help

Page 1 of 2 12 Last

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•