Results 1 to 9 of 9

How to calculate elapsed time between to days excluding weekends.

Threaded View

Mush001 How to calculate elapsed time... 11-23-2009, 08:06 AM
DonkeyOte Re: How to calculate elapsed... 11-23-2009, 08:14 AM
Mush001 Re: How to calculate elapsed... 11-23-2009, 08:22 AM
DonkeyOte Re: How to calculate elapsed... 11-23-2009, 08:24 AM
Mush001 Re: How to calculate elapsed... 11-23-2009, 08:44 AM
daddylonglegs Re: How to calculate elapsed... 11-23-2009, 09:05 AM
Mush001 Re: How to calculate elapsed... 11-23-2009, 09:48 AM
daddylonglegs Re: How to calculate elapsed... 11-23-2009, 12:24 PM
Mush001 Re: How to calculate elapsed... 11-23-2009, 04:19 PM
  1. #6
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    14,695

    Re: How to calculate elapsed time between to days excluding weekends.

    The number format dd:hh:mm doesn't work for durations over 31:59:59 because the dd part is actually a day of the month so 31 is actually 31st January, go to 32 days and it reverts to 1 (1st Feb).

    You either have to use decimals, i.e. just format as a number with 2 decimal places so you'd get 83.68 for the above example (0.68 of a day representing 16:23)....or if you want to see 83:16:23 then try this formula

    =NETWORKDAYS(C10,D10)-1-(MOD(C10,1)>MOD(D10,1))&":"&TEXT(D10-C10,"hh:mm")

    Note: this gives a text result so it's not so easy to use in any further calculations you may require
    Last edited by daddylonglegs; 11-23-2009 at 09:08 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1