Hi Guys,

I hope you are all having a great friday

I was just wondering if anyone could help me combine the power of Networkdays and IF Statement so currently

I have a start Date In A1 and End Date in B1 then either AM,PM Or Full in C1 with the days total in D1

I wondered if anyone would know how to merge NetworkDays & IF together so if there was AM Or PM in C1 it would only count as 0.5 and if Full it would count as 1.

any help would be greatly appreciated

Jamie