Calculating half days with NETWORKDAYS.INTL

[chrisPg]

I am attempting to use excel to track the number of days leave employees have taken for a holiday accrual calculation.

I am using the NETWORKDAYS.INTL function with string values to deal with part-time employees who work complete days, however I have a handful who work a mix of whole and part days (for example full days Mon, Tues, Weds plus half day on Thursday.

The data I am using to calculate leave days taken just gives me the start and end date of the leave period, so I need to be able to recognise that any Thursdays appearing in the date range only represent a half day of leave allowance used, not a full day.

 

[sergioMabres]

Hi Chris you could use this formula

=NETWORKDAYS.INTL(B2,C2,1)-((C2-B2)-NETWORKDAYS.INTL(B2,C2,15)+1)*0.5

To calculate days where THU is half day
Where B2 is start and C2 is end
Cheers
Sergio