NETWORKDAYS formula
 

I am using the formula below to calculate a Total Time to Resolution
(TTR). I need to add a (possibly NETWORKDAYS) formula that will
calculate the TTR only between the hours of 6AM and 7PM (13-hour
clock).

G2 = Pending Time (not all cells have a value)
H2 = Resolved Time
D2 = New Time

=IF(ISBLANK(G2),(H2-D2),((H2-D2)-(H2-G2)))

Thanks in advance,

LJ

NETWORKDAYS formula
 

Networkdays filters out non-working days like Saturday, Sunday and holidays.
It won't filter out non-working hours.

To determine the appropriate solution, we need to know what days you want
included. Are weekends and holidays working days, or do you want them
excluded too? Also, your formula reduces to the following:
=if(isblank(g2),h2-d2,g2-d2))
Is this actually what you want?

Regards,
Fred

"LJ" wrote in message
...
I am using the formula below to calculate a Total Time to Resolution
(TTR). I need to add a (possibly NETWORKDAYS) formula that will
calculate the TTR only between the hours of 6AM and 7PM (13-hour
clock).

G2 = Pending Time (not all cells have a value)
H2 = Resolved Time
D2 = New Time

=IF(ISBLANK(G2),(H2-D2),((H2-D2)-(H2-G2)))

Thanks in advance,

LJ