Network Days & IF Statements

[bloodmilksky]

Hi guys,

I was just wondering if anyone could help me with this query.

I have a holiday calendar and I am totalling the days taken as holiday using NETWORKDAYS

B1 C1 D3
02/01/2016 + 05/01/2016 = 2 (Networkdays)

But what I was wondering is if there is a way of incorporating an IF statement into this sum So if AM/PM followed the date it would only count as 0.5 but if Full followed the date it would count as 1.

B1 C1
02/01/2016AM + 02/01/2016AM = 0.5 (Networkdays)

B1 C1
02/01/2016FULL + 02/01/2016FULL = 1 (Networkdays)

any help would be greatly appreciated

Many thanks

jamie