Page 2 of 4 FirstFirst 1 2 3 4 LastLast
Results 11 to 20 of 38

Thread: Formula for tracking my hours worked including overtime etc

  1. #11


    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi Bob, I sent you a PM. I would like to send you my file. Not sure how to just attach here

  2. #12
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,663
    Articles
    0
    Excel Version
    O365
    Reply to the thread, click the 'Go Advanced' button, there is a button there below the response box to 'Manage Attachments'

  3. #13
    Hi Bob, this is the file im trying to work on, your formula is on the second tab at the bottom and a formula that "sambit" is working on. Just to prove how much of a noobie I am I had password protected the sheet so if it requires it when you go to open it the pass word is"07231971"
    Attached Files Attached Files

  4. #14

    The sheet im working on

    Hi, this is the sheet im working on and the tabs at the bottom are from yourself and another gentleman that is helping me with this formula. Maybe this will explain better.
    Attached Files Attached Files

  5. #15
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,663
    Articles
    0
    Excel Version
    O365
    It's password protected.

  6. #16
    Sorry "07231971"

  7. #17
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,663
    Articles
    0
    Excel Version
    O365
    In the formula that I gave you in post #9, just change the THU to THUR.

  8. #18
    Sorry cant believe I did that. Although this isn't a huge deal the formula definitely works, if you were to say show no hours on one of the first 4 days then would it be possible for it to redo the cells so that for example
    SUN 0.0 0.0
    MON 5:00 AM 7:00 PM 10.0 4.0
    TUE 5:00 AM 7:00 PM 10.0 4.0
    WED 5:00 AM 7:00 PM 10.0 4.0
    THU 5:00 AM 6:00 PM 4.0 9.0
    FRI 5:00 AM 6:00 PM 10.0 3.0
    SAT 5:00 AM 9:00 PM 0.0 16.0


    SO THAT MON, TUE, WED, THU SHOW 10 HOURS IN THE REG COLUMN
    FRI SHOWS 4 HOURS IN THE REG COLUMN AND THE REST OT
    SAT WOULD BE STRAIGHT OT

  9. #19
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,663
    Articles
    0
    Excel Version
    O365
    Isn't that what it returns?

  10. #20
    It does get to the 44 total regular hours. I will re-attach the file and you will be able to see, I keyed 0 hours in on the first day of the week and then 14 hour shifts for the rest of the week.
    SUN 0.0 0.0
    MON 5:00 AM 7:00 PM 10.0 4.0
    TUE 5:00 AM 7:00 PM 10.0 4.0
    WED 5:00 AM 7:00 PM 10.0 4.0
    THU 5:00 AM 7:00 PM 4.0 10.0
    FRI 5:00 AM 7:00 PM 10.0 4.0
    SAT 5:00 AM 7:00 PM 0.0 14.0
    So you can see it shows the thu shift as 4 reg and then 10 OT.
    Ideally the last shift of the week before I start into straight OT should be the shift that is making up the last few hours of regular time to get to the 44. Does that make sense.
    Attached Files Attached Files

Page 2 of 4 FirstFirst 1 2 3 4 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
  •