Consulting

Results 1 to 2 of 2

Thread: Need help with NETWORKDAYS.INTL()

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 05-21-2022, 06:04 AM #1
    sam_011
    sam_011 is offline
    VBAX Newbie
    Joined
    May 2022
    Posts
    4
    Location

    Post Need help with NETWORKDAYS.INTL()

    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
    Last edited by sam_011; 05-21-2022 at 06:58 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules