overtime

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> I can calculate my overtime into 2 diferrent rates including weekends, but I need to enter manually any 2UP (Row/Cell AH) or Wait time hours (Row/Cell AM)which both need to be deducted from the daily hours...

Ok, I have created a fairly large spreadsheet that figures all the work time for employees, including sick time, holiday, vacation, etc. My question is the way I currently have this set up, time is based on a day by day basis, i.e. Mon-Fri, and if someone were to work more than 8 hours, it would...

I'm trying to figure out the formula for a timesheet. I have one rate for "drive time", another rate for "service time". But if the start time is after 17:00, then it's an overtime rate. Then Saturday/Sunday rate creates another variable. I've looked through the posts and can't find a...

(This is Sooo Bad, I had all this typed and lost it in the preview) (This time I "ctrl+c" everything before preview) (In preview my pic didn't show, I used the wrong link: "Use the second one") I am creating a weekly expense report that includes pay Daily Hours <= 8 $10.00 Daily Hours > 8...

OK... I've been staring at this for a few weeks now and I just cant figure it out. I work for a very complex company that change rules, schedules, pay etc. all the time. Because they do this, they have a horrible reputation for not getting our paychecks correct. So I wanted to create a...

I am preparing a worksheet that will calculate a worker's normal working hours and overtime working hours. The value in A1 minus B1 will show result in C1 and D1 If the result form A1 minus B1 exceeds 8, the value 8 will go show in C1 and the remaining value shows up in D1. For example: 12 is...