Networkdays
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Networkdays

  1. #1
    New Member MikeLevine's Avatar
    Join Date
    Apr 2002
    Location
    Dexter, Michigan, USA
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    The networkdays() function returns the number of whole workdays between two dates (and holidays if used). What function can I use to return the fractional portion of workdays?

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Calgary, Alberta Canada
    Posts
    3,327
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default


    You can use regular arithmetic.

    Start
    18:00
    13:00
    5:00 =D4-D5

    Days per Function calculation (say 4) and
    regular hours per day (8)

    =4*8

    Does this answer your question?

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-05 05:09, MikeLevine wrote:
    The networkdays() function returns the number of whole workdays between two dates (and holidays if used). What function can I use to return the fractional portion of workdays?
    http://www.mrexcel.com/board/viewtop...c=4027&forum=2

    might get you started, let me know if you need more.
    "Have a good time......all the time"
    Ian Mac

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Denver, CO
    Posts
    1,743
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    one more link, in case you need it

    http://www.mrexcel.com/board/viewtop...ic=525&forum=2

    good luck

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com