HannahNeedsHelp
New Member
- Joined
- Jul 7, 2017
- Messages
- 15
Hello,
Trying to exclude non-working hours from the calculation of processing time by employees. Keep getting Name errors using this formula:
=Networkdays (Received, Processing End)-1)*(Stop time-Start time)+IF (NETWORKDAYS(Processing End, Processing End), MEDIAN(MOD (Processing End,1),Stop time, Start time),Stop time)-MEDIAN (NETWORKDAYS (Received, Received)*MOD (Received,1),Stop time,Start time)
Categories are:
Received (time we get the request)
Processing End (time it's completed)
Start time 8:00
End time 11:00 pm
(Want to exclude 11pm-8am from calculation as these are non working hours.
Thanks!
Trying to exclude non-working hours from the calculation of processing time by employees. Keep getting Name errors using this formula:
=Networkdays (Received, Processing End)-1)*(Stop time-Start time)+IF (NETWORKDAYS(Processing End, Processing End), MEDIAN(MOD (Processing End,1),Stop time, Start time),Stop time)-MEDIAN (NETWORKDAYS (Received, Received)*MOD (Received,1),Stop time,Start time)
Categories are:
Received (time we get the request)
Processing End (time it's completed)
Start time 8:00
End time 11:00 pm
(Want to exclude 11pm-8am from calculation as these are non working hours.
Thanks!