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