I use Excel 2010.
A41 = Start Date & B41 is End Date, And I have in C41 a networkday formula to determine the working days between de start and end date. (=NETWORKDAYS($A$41,$B$41)
In E42 I can determine if we work 37.5, 38 or a 40 -hour workweek.
What I want.
In D41 I want a formula which calculate the total hours for one Full-Time FTE based on the amount of working days and the amount of hour for a workweek.
Example 1
C41 = 5 working day
E42 = 40 hour workweek
Then D41 = 40 hours (=Hours for One Full-Time FTE)
Example 2
C41 = 10 working day
E42 = 40 hour workweek
Then D41 = 80 hours (=Hours for One Full-Time FTE)
Can someone help me please?
Thanks in advantage,
Best regards
Ellerd
A41 = Start Date & B41 is End Date, And I have in C41 a networkday formula to determine the working days between de start and end date. (=NETWORKDAYS($A$41,$B$41)
In E42 I can determine if we work 37.5, 38 or a 40 -hour workweek.
What I want.
In D41 I want a formula which calculate the total hours for one Full-Time FTE based on the amount of working days and the amount of hour for a workweek.
Example 1
C41 = 5 working day
E42 = 40 hour workweek
Then D41 = 40 hours (=Hours for One Full-Time FTE)
Example 2
C41 = 10 working day
E42 = 40 hour workweek
Then D41 = 80 hours (=Hours for One Full-Time FTE)
Can someone help me please?
Thanks in advantage,
Best regards
Ellerd