Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
~~~ Distinguishing Normal; X1.5 and X2 Hours throughout the week by what day and time they are worked ~~~
I am trying to set up a time sheet.
I have looked at some Excel samples but i cannot find any to suit my needs as yet. I Have an Excel Sheet designed, but am having a little trouble working out how to SET the weekday Hours of : Mon-Fri 7:30AM - 3:30PM as NORMAL TIME (This is a 8hr time frame, but is paid as 7.6hrs, dur to the minus of a lunch Break) Mon-Fri the 1st (3) hrs in excess of the above NORMAL hrs are paid at TIME & HALF (1st 3hrs worked on a SATURDAY are also TIME & HALF) Any other hours outside of the above times are paid at DOUBLE TIME If i can manage to get some assistance i would like this sheet to be coded, to avoid having complex CALULATIONS, and the chance of them being accidently modified. To make things a little more confusing, i need more than one (1) RATE, depending on a Cell Value. This is because if an employee is working on certain sites he then must be paid a higher rate of pay. Worked hours in general sites his/her rate remains the same. I need to set up a sheet for each employee as each employee is on a different base rate due to skill levels. Basically i need some assistance witht the code to break up the Start and Finish Times each day into the Correct pay categories, these could be: NORMAL TIME (1) TIME & HALF (1.5) DOUBLE TIME (2) SITE RATE NORMAL (1) ) SITE RTE TIME & HALF (1.5) These rates will need to be identified by a Cell Value of say [SITE;WORSHOP] SITE RATE DOUBLE (2) ) Any help is appreciated, either with CODE setup or Formulas if i must go that way. Regards Corey |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function to calculate total hours worked in one week. | Excel Worksheet Functions | |||
total Hours Worked for week PS thx for the formulars everyone! | Excel Worksheet Functions | |||
Figure out the hours worked for the week | Excel Worksheet Functions | |||
Getting a total of hours & mins worked per week | New Users to Excel | |||
Excel needs hh:mm where hh>24 for hours worked per week | Excel Worksheet Functions |