Hours Between the Days

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.
 

Attachments

  • SLA Calc.xlsx
    13.7 KB · Views: 4
Last edited:
Thanks For the Quick Response. The amendment in the Formula worked.
Will Explore More on the new Learning :)
Thanks Once again.
 
Hi.
The above formula only works if the ticket is closed next working day. If the ticket is aged for say 4 days, the formula gives incorrect output.
Can you please advise.
 
Back
Top