Forum Discussion
Working time formula
Thank you, but that won't add on the extra time.
So if they have 5 days leave in that period then it will be 17 weeks + 5 more daysSergeiBaklan
JohnBoy1995 Perhaps I'm over-simplifying, but if you enter 0 (zero) hours on a Leave day, you can use =AVERAGE(<range>).
For example, if a person worked 4 days of 8 hours and took leave 1 day, the average will become (8+8+8+8+0)/5 = 6.4hrs per day. Multiply by 5 (or 7) and you have the average number of hours per week.
I like your example but yes that is over simple 🙂
eg 1 week I work 4 hours a day for 4 days, take leave on friday and have the weekend off. ((4+4+4+4+0+0+'What ever hours I work the following monday')/7) Riny_van_Eekelen
JohnBoy1995 And how would you count that following Monday? Is it to be excluded from the following week?
Taking the first two weeks in your file as an example. You have 14 days in total, 61 hours worked, 1 day leave and 5 days off. What would you like to see as the average hours for these two weeks?
So if I was working out buy hand for the average hours for 2 weeks I would count 15 days because of the 1 day leave.
I have to count 14 days that they worked or had days off. Leave or sick has to be removed Riny_van_Eekelen