Forum Discussion
Working time formula
Hi, I need to write a formula to work out the average working time for staff over a 17 week(119 days) period. But if they use 'leave' then I must discount this day and add on the next working day...
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
