Need help with NETWORKDAYS.INTL()

[sam_011]

Hello,

How can we use NETWORKDAYS() function count working hours of team, Our team works Sunday 22:30 - Friday 17:30 24 hour shift.
When i use NETWORKDAYS() function to count working hours it count full Friday and exclude 1:30 hr from Sunday, so is there any way i can use NETWORKDAYS() for our Ticket hour within Sunday 22:30 - Friday 17:30 window.


* can we edit excel built-in functions? because if i can edit NETWORKDAYS() to start weekend on Friday 17:30 and end weekend on Sunday 22:30 then my problems will be easily solved.

Thanks

[Aussiebear]

Networkdays works with whole days not partial days. Can you show us an example( within a worksheet) of how you intend to record Start and Closure times for the tickets? Until then we are simply trying to teach rabbits to climb tall trees.