Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Complex Formulas possibly using IF
I am in the process of creating a worksheet for the entry of timesheet and
the costings of this timesheets. What I need to do is once I have enter the total Hours that an employee has worked for a specific job in cell N7, then I need the hours to breakdown according into Normal Time, Time and a half and Double Time, but this is also specific to the day that the employee is working. Monday to Thursday the Breakdown is: 8Hrs - Normal Time 3hrs - Time and a half Rest - Double Friday's Breakdown 6Hrs - Normal Time 3hrs - Time and a half Rest - Double Saturday's Breakdown 3hrs - Time and a half Rest - Double Sunday's Breakdown 6Hrs - Normal Time 3hrs - Time and a half Rest - Double But I need it to take into account if he works less then 8 Normal Time when working account several different jobs for the day. I know that it is complex and hopefully you are able to assit me. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Complex Formulas possibly using IF
You could do something like this to figure out the time for each day
=SUMPRODUCT(--(A1:A10="Employee Name"),--(C1:C10 = Date(2008, 8,21)),(B1:B10)) Where A1:A10 contain all of the employee names B1:B10 contain the hours worked C1:C10 contain the dates worked You could replace Date(2008, 8,21) with Date(Year(E1),Month(E1),Day(E1)) where E1 contains the date of interest If you want to figure out the day of the week, use the WEEKDAY function. =-- HTH, Barb Reinhardt "Rallie" wrote: I am in the process of creating a worksheet for the entry of timesheet and the costings of this timesheets. What I need to do is once I have enter the total Hours that an employee has worked for a specific job in cell N7, then I need the hours to breakdown according into Normal Time, Time and a half and Double Time, but this is also specific to the day that the employee is working. Monday to Thursday the Breakdown is: 8Hrs - Normal Time 3hrs - Time and a half Rest - Double Friday's Breakdown 6Hrs - Normal Time 3hrs - Time and a half Rest - Double Saturday's Breakdown 3hrs - Time and a half Rest - Double Sunday's Breakdown 6Hrs - Normal Time 3hrs - Time and a half Rest - Double But I need it to take into account if he works less then 8 Normal Time when working account several different jobs for the day. I know that it is complex and hopefully you are able to assit me. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help with some rather complex formulas... | Excel Worksheet Functions | |||
Need help with some rather complex formulas...... | Excel Worksheet Functions | |||
Need help with some rather complex formulas... | Excel Worksheet Functions | |||
Complex Formulas | Excel Worksheet Functions | |||
Complex If Then formulas | Excel Worksheet Functions |