count between dates help (NETWORKDAYS)

  • Thread starter Thread starter Montys Python {wink wink}
  • Start date Start date
M

Montys Python {wink wink}

Hello big brains



I am trying to find the days and hours between 2 dates

2 columns of dates formated in M/D/YYYY hh:mm

4/23/2004 15:53 and 4/27/2004 10:43

I don't want to count weekends so I used NETWORKDAYS which works to a
degree.. giving me 3 (which is days) but it's ignoring the time. I
need it to be specific and have it show days and hours difference. I
am suprised that it is ignoring it.

Unfortunately I am kind of stuck with the dat being in this format.
Any help would be appreciated.

thanks
 
thanks for the pointer

It looks promising but I am having difficulties making it work.

I'm assuming that in that formula StartDT and EndDT can be substituted
for the Cells that contain the dates...where as the example uses a
fixed date. Maybe thats the problem....
 
Here is what I have

Cell B118 Cell C118
4/23/2004 15:53 4/27/2004 10:43


With the rest of column B & C populated with dates/times

this formula results in a formular error

=IF(AND(INT(B118)=INT(C118),NOT(ISNA(MATCH(INT(B118),A127,0)))),"0
days 0 hours", IF(INT(B118)=INT(C118),"0 days " &
ROUND(24*(C118-B118),2)&"hours",MAX(NETWORKDAYS(B118+1,C118-1,HolidayList),0)+INT(24*(((C118-INT(C118))-(B118-INT(B118)))+(20:00-9:00))/(24*(20:00-9:00)))&"
days
"&MOD(ROUND(((24*(C118-INT(C118)))-24*9:00)+(24*20:00-(24*(B118-INT(B118)))),2),ROUND((24*(20:00-9:00)),2))&"
hours "))

I don't have any Holidays so I pointed that to a blank cell.

I'm a bit lost on all this...

thanks for anything you can offer
 
Back
Top