+ Reply to Thread
Results 1 to 8 of 8

crazy formula, please help! OVERTIME

  1. #1
    Registered User
    Join Date
    04-10-2008
    Posts
    4

    Question crazy formula, please help! OVERTIME

    ok, i need a formula for an overtime spreadsheet.
    "A1" is hours worked, "B1" is employee name, then "C1:whatever, let's say AB1" represents each day they get overtime. ok so "B1"=mike, he gets 12 hrs overtime today. "B2"=john, he gets 24 hrs overtime the same day or next day, he will drop under mike, because mike only had 12 total. column "A1" through "A50" has =MIN, so the top employee is sorted on top to be offered overtime first, because he has the least amount of overtime. column "B" is just the names of the employee. then each day the employee is offered overtime, wether they take it or not, the hrs are put into "C1,D1,E1, etc." and the total is added into column "A". I have everything fine with the formulas, but how do i just enter the hrs in C1,D1,E1 and that person drop to his right place in the time total offered overtime in column "A". kind of like a golf score. let's say the leader ontop of the list is -8, and shoots a triple bogey to drop to -5. once you post his -5.....i want it to automatically place the golfer down the list with his stats and total score to lets say 5 or 6 golfers down (or rows) to between the -6 and -4 players. the way it works is overtime is offered to the person on top of the list. if he takes it or not he is charged, lets say 24 hrs, and will drop down the list. and so, on. IE:row 2 says A=1000,B=john,C=24. then 1000 will turn into 1024 and drop john down the list..........is there a formula or program to keep track of this and keep the total hrs with the names and the individually offered dates with hrs and drop them in place down a list, just by entering in the individually hrs????????? this would be huge help. thanks, mike.

  2. #2
    Forum Contributor Portuga's Avatar
    Join Date
    02-20-2004
    Location
    Portugal
    MS-Off Ver
    365
    Posts
    852
    can you zip a small sample of your data and post it in the thread?
    If you found the solution to your question. Mark the thread as "Solved"
    Thank everyone that helped you with a valid solution by clicking on their

    There is no such thing as a problem, only a temporary lack of a solution

  3. #3
    Registered User
    Join Date
    04-10-2008
    Posts
    4

    Question here is a sample

    when i enter in overtime how can i write a formula to drop all of employees info and refused/taken overtime down the list. kind of like a golf score. when the top guy drops a few slots, he moves down the list, but keeps his info with him. country, stats, etc.
    Attached Files Attached Files

  4. #4
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161
    Foxy take a look at the attached i couldn't really understand what you are trying to achieve and it looks like a minefield glad i dont have to maintain it!

    That said does the attached do what you want if you make a change?
    Attached Files Attached Files
    Not all forums are the same - seek and you shall find

  5. #5
    Registered User
    Join Date
    04-10-2008
    Posts
    4

    here is a zip

    here is a zip of the spreadsheet
    Attached Files Attached Files

  6. #6
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161
    Foxy34 that zip doesn't make things clearer as it is exactly the same as the excel file you uploaded, did my code addition to your workbook do the trick?

  7. #7
    Registered User
    Join Date
    04-10-2008
    Posts
    4

    combat overtime

    i am sorry i didn't copy enough for it to add up right. this is a better sheet. here's what i want...let's say you add 3 hrs in box $BL $5. that would make paramedic Wolfe have 3567.5 hrs and should move down between paramedics Saverese and Woerner. Foxes Rows which are 6 & 7 will move up to 4 & 5, and so on. all i want to do is enter the hrs offered in column BL, Row 5 and this information change. is this possible or do i have to move all of the columns everytime. is there a way i can keep all the info together ( like grouping them as one) so when the total hrs of this paramedic move, so do his name and all the other days and hours he was offered overtime??? thanks, i know this a tuff one, but it is like golf. if you go to masters.com and look at the leaderboard, this happens. the leader may drop 4 places down on the list, but keep his country, stats, round info, etc.......thanks
    Attached Files Attached Files

  8. #8
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161
    The code i supplied in the workbook should do just that!, when a "score" line has some new figure i.e column BL i added 4.5 hours for Wolfe and the program made him 4th from the bottom as his total hours or "Score" was more than the top of the board but not as much as the bottom of the board!

    Other than that i cannot seem to get what you want.
    EDIT: Just tried it with the 3 hours you state and the outcome was as you also stated!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1