IF Statement Or Select Case Help Please

[bloodmilksky]

Good Morning Guys, I hope you are all well.

I am just in the process of setting up a new part time employee on a Holiday Spreadsheet I have made which uses NETWORKDAYS to determine the amount of holiday the user is after.

So when the User selects for example 12.04.17-13.04.17 that would be 2 work days.

This would then book these dates on the calendar and using a simple sum takes this of their total days.

However with this new user her full days are as follows

• Monday 6.75hrs
• Tuesday 6.75hrs
• Wednesday 6.50hrs
• Thursday 5.00
• Friday 5.00

What I wanted to know was if there is anyway of amending the below to show that IF "Jane Doe" appears in cell B7 then the value of one day changes depending on the day that she requests or that if "Jane Doe" Requests a Whole Week it would only come to 30hrs

=IF(OR(D21="AM",D21="PM"),NETWORKDAYS(B21,C21)/2,NETWORKDAYS(B21,C21))

Or if anyone knows how I could set up a select case to reflect the same thing.

 

[gaz_chops]

You could probably use a lookup if the name is Jane Doe.

=if(B7="Jane Doe",lookup,IF(OR(D21="AM",D21="PM"),NETWORKDAYS(B21,C21)/2,NETWORKDAYS(B21,C21)))