R
Rallie
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.
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.