Thread: Elapsed Time (h):mm:ss Thanks: 0 Likes: 0

1. Re: Elapsed Time (h):mm:ss

The formula I provided was copied from a tested environment.
It calculate the total elapsed time in the first part. Then subtracts the number of days not available. The number of days not available is the total number of days less the number of workdays as provided by the Excel function NETWORKDAYS.

2. Re: Elapsed Time (h):mm:ss

I re-formatted the columns and this does seem to work other than it is adding 24 hours to the results?

3. Re: Elapsed Time (h):mm:ss

I used a deferent formula that seems to be working i.e. +NETWORKDAYS(stat,end,Holdays)+start-end-INT(end-start)-1 The only issue with this is the elapsed time columns full of #### what would need to be added for the elapsed time column to be blank until there is a date/time in the end column?

4. Re: Elapsed Time (h):mm:ss

Sorry beginning of formula is =NETWORKDAYS not +

5. Re: Elapsed Time (h):mm:ss

Originally Posted by Red Corvette
Sorry beginning of formula is =NETWORKDAYS not +
That's a LOTUS thing.

"########" as a result formatted as a date/time may indicate the resultant value is Negative. Try inversing with a -1.

6. Re: Elapsed Time (h):mm:ss

Originally Posted by SpillerBD
Code:
`=(EndDate-StartDate)-(DAYS(EndDate,StartDate)-NETWORKDAYS(StartDate,EndDate,HolidayList))`
NETWORKDAYS will provide a result of 1 for the same day.
Minor modofication.

Code:
`=(EndDate-StartDate)-(DAYS(EndDate,StartDate)-NETWORKDAYS(StartDate,EndDate,HolidayList)-1)`