L
LJ
I currently use an IF formula (see below) to track total time to
resolve
an issue. Sometimes, the issues are placed in a Pending status so
there is a need to use the IF function.
I need the current formula below to use NETWORKDAYS to calculate
issues between 7AM and 6PM Monday-Friday. Please help me insert
NETWORKDAYS into
the formula below.
=IF(ISBLANK(D2),B2-C2,D2-C2)
B2 = End Time
C2 = Start Time
D2 = Time spent in Pending Status
resolve
an issue. Sometimes, the issues are placed in a Pending status so
there is a need to use the IF function.
I need the current formula below to use NETWORKDAYS to calculate
issues between 7AM and 6PM Monday-Friday. Please help me insert
NETWORKDAYS into
the formula below.
=IF(ISBLANK(D2),B2-C2,D2-C2)
B2 = End Time
C2 = Start Time
D2 = Time spent in Pending Status