sonbarse
New member
- Joined
- Sep 15, 2019
- Messages
- 3
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2016
I need to calculate the Total hours an Incident/Ticket been live in system. I have incident login date/time & incident closed date/time.
Working days are : Saturday to Thursday (Friday is OFF day)
Working Hours are : 7AM to 6PM
I tried the NETWORKDAYS formula in array, but the formula by default uses Saturday/Sunday as weekends & hence my answer is wrong.
Can some Expert help me to fix this
Have added my worksheet in attachment.
Expert please advise.
Thanks in Advance.
Working days are : Saturday to Thursday (Friday is OFF day)
Working Hours are : 7AM to 6PM
I tried the NETWORKDAYS formula in array, but the formula by default uses Saturday/Sunday as weekends & hence my answer is wrong.
Can some Expert help me to fix this
Have added my worksheet in attachment.
Expert please advise.
Thanks in Advance.