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