I have a timesheet created, with the examples that were in the forum.
I've gotten a lot of help, but knowledge is invaluable. (sigh)
I do not get out in the totals of hours.
1st attachment is how I filled my hours.
it's a bit clumsy, but for me it was eventually cluttered.
zonder puntjes.xlsm
2nd attachment is with the help of fellow forum users become more beautiful.
But ....
there are some points that can be better.
Map3.xlsm
In column O : normal hours 100 % there is 8 hours .
but if I have to work 4 hours, 4 hours standing. (Mon - Fri)
If I work more than 8 hours than the extra hours should be allocated.
My Employer is flexible with working hours, if total working hours is 8.
If there is little work, you finish work, clean up and go home. This is less than 8 hours of work.
In a quarterly census will only work on a Saturday .
Again, it is the more people count of the faster we go home .
Column T and U is the total hours worked (= sum of column N)
Box U4 : I have worked fewer hours , even if I have overtime one day .
I have 38 hours worked including overtime pay everything as 38 hours .
I have 40 hours worked including overtime pay everything as 40 hours .
I have 48 hours worked including overtime pay over 40 hours and 8 hours for holiday savings . ( Leave)
All times are entered as military format manually. 800 hours is 8:00.
Please work step by step. that i understand the formule.
keep the layout the same, if possible.
many thx/ love,
Mofasa
Moderator's note: See also this thread posted in Dutch --6StringJazzer
Bookmarks