Calculating leave days using NETWORKDAY function.

[matthagon1]

Hello

I am building a spreadsheet to calculate how much leave employees have taken. I have used this formula so far =NETWORKDAYS(start_date, end_date, [holidays]). However as some leave periods are for part of a day, I need a formula to work out a period, such as 1.5.
The working day is generally 8:30 until 16:00, would I have to work this into the formula somehow?

 

[awoohaw]

I'm not sure a networkdays formula will work for your scenario. That function counts days and not portions of days.
Can you provide some data and maybe the forum can provide you with a way to do your task. Please post data as a table or use the xl2bb add in (link below ).
Also provide some examples with expected outcomes.

 

[bebo021999]

1- Using NETWORKDAYS to count full days first (i.e, 5)
2- Then, minus portion days.
i.e, last day, end hour is 12 PM
result should be =5-(12-8.5)/7.5

 

[matthagon1]

I'm not sure a networkdays formula will work for your scenario. That function counts days and not portions of days.
Can you provide some data and maybe the forum can provide you with a way to do your task. Please post data as a table or use the xl2bb add in (link below ).
Also provide some examples with expected outcomes.

Thank you @awoohaw i appreciate your reply. I will get a sample spreadsheet loaded up so you can see what i mean.

 

[matthagon1]

Start Date / Time	End Time		Should be
9/26/2024 8:00:00	9/27/2024 16:00:00	2
12/1/2024 8:00:00	12/6/2024 16:00:00	5
9/27/2024 8:00:00	9/28/2024 12:00:00	1	1.5
5/21/2024 8:00:00	5/26/2024 12:00:00	4	3.5
			Holidays
			5/24/2024
			5/25/2024

This is the data that i am using, with a column stating what the outcome should be.

 

[awoohaw]

are the partial day times only on the first or last day?

 

[awoohaw]

also, are you wanting to exclude weekend days, if so which days define your weekend?

 

[matthagon1]

They can be either, some will leave halfway through the day and vice versa

are the partial day times only on the first or last day?

 

[matthagon1]

Yes, weekend days are Saturday and Sunday.

also, are you wanting to exclude weekend days, if so which days define your weekend?

 

[awoohaw]

Yes, weekend days are Saturday and Sunday.

are they to be excluded like the holiday?