Log In
Register
Home
March 10, 2016
Offline
Hi,
From France file of working hours calculation
My rule -
Employee must work 7.4 a day + must work 37 hours a week
The days off are Saturday
So a week is considered Monday - Saturday
In the attached table are the dates 6 / 1-10 / 1
My question - how do I summarize in cell G13
The cells of that week - F9: F13
That's what I need every week
And every month the range of cells changes - so I can't do a manual summary
So thank you for your help -
How to make a smarter summary that knows how to take Monday - Saturday cells
Double several times that month.
Thanks for the response!!
Leah
See Answer
VIP
Trusted Members
December 7, 2016
Offline
Hello,
If I were you I would go with a Pivot Table solution. This reply is not really answering your question, but show an example of how easier it is with using a Pivot Table. No need for formulas.
I have added two columns, G and H, which are showing week number (as number) and weekday (as text).
I don't get you correct if Saturday is to be counted in or not, as you write that Saturday is a day off, but later you write that you want a sum of hours for Monday to Saturday. The Pivot Table is showing Saturdays, but that can be changed.
Br,
Anders
Answers Post
March 10, 2016
Offline
Thank you!!
Great answer, smart solution !!
About ISOWEEKNUM function -
Does she automatically count a week from Monday?
And if you want to count a week from Sunday - what to do?
VIP
Trusted Members
December 7, 2016
Offline
Hello,
Thanks, I am glad I could give some help.
You can read more about ISOWEEKNUM in this blog post. If that does not suit your purpose, for example if you want to start the week from Sunday, you can always use the old WEEKNUM function instead.
Br,
Anders
1 Guest(s)
