Weeknum - Formula

[Meelkoppie]

Hi.

Please, I need a formula to determine the total hours for a specific Week, excluding weekends. Please see attachment. My input is the person’s name, start and end - date and hours per day. I need to select a week, for example Week 48 and it must calculate the total hours per person. Your assistance will be much appreciated.



Input Selection

Name Start End Hours/day
John 17/11/2014 30/11/2014 4
Paul 20/11/2014 25/11/2014 2
Herman 22/11/2014 02/12/2014 1


Select WEEK48

Needed Results

Name Total hours (Exl week-ends)
John 20
Paul 4
Herman 5

[ELeGault]

You seem to be missing attachment.
Go advanced and add it so that we can further assist.