NETWORKDAYS

[LJ]

I currently use a 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 M-F. 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

 

[Ms-Exl-Learner]

Hi,

I don't know why you are looking to go for Networkdays function. Just
confirm M-F is about the gender of that person or something else and
in which cell it is present. Give the above info to provide the exact
formula.

 

[David Biddulph]

I think you'll find that "M-F" means Monday to Friday, hence the reference
to NETWORKDAYS.