Combine IF and NETWORKDAYS

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top