Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    New Lounger
    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 Dec-13 Jan

    Any advice and examples would be appreciated. Please send example attachments.

    Thanks,
    Dale

  2. #2
    Super Moderator RetiredGeek's Avatar
    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

  3. #3
    New Lounger
    Join Date
    Jan 2012
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    How do I remove an account?

  4. #4
    Gold Lounger
    Join Date
    Oct 2007
    Location
    Johnson City, Tennessee, USA
    Posts
    3,202
    Thanks
    37
    Thanked 215 Times in 202 Posts
    Quote Originally Posted by lawyerdp. View Post
    How do I remove an account?
    Log Off ....I'm on it Regards Fred
    Last edited by Just Plain Fred; 2012-01-14 at 21:20.
    PlainFred

    None are so hopelessly enslaved as those who falsely believe they are free (J. W. Von Goethe)

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

    Any advice and examples would be appreciated. Please send example attachments.

    Thanks,
    Dale
    Last edited by Lounge2012; 2012-01-14 at 23:36.

  6. #6
    New Lounger
    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

  7. #7
    Super Moderator RetiredGeek's Avatar
    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)
    Attached Files Attached Files
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  8. #8
    New Lounger
    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?

  9. #9
    New Lounger
    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

  10. #10
    New Lounger
    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

  11. #11
    New Lounger
    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

  12. #12
    Super Moderator RetiredGeek's Avatar
    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

  13. #13
    New Lounger
    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; 2012-01-16 at 15:26.

  14. #14
    Super Moderator RetiredGeek's Avatar
    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)
    Attached Files Attached Files
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  15. #15
    New Lounger
    Join Date
    Jan 2012
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts
    It works outstanding thanks a ton for all your help

Page 1 of 2 12 LastLast

Posting Permissions

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