Posts by zia.ziahussain

    Re: Working Hours and Days calculations

    Thanks a ton NBVC for taking out your time to help me.However, the formulae given below does not solve the issue.Let me explain more what I am trying to dy by an example:

    Working days are from Monday to Friday and the Day start @09:00 am to 23:00 (11pm)

    For example the first case was recd on 9/16/2013 11:04

    So the number of hours it remained open on 16 sept is 23:00-11:04=11:56 hours

    And it was resolved on 17 September.So the number of hours it remained open on 17 sept is 09:00-13:01=04:01

    So the total resolution time is 11:56+04:01=15:57 hours

    Can you give it a shot again..


    I am trying to generate the SLA breach report for a helpdesk.The SLA is 42 hours(working). I am trying to calculate the Network Days and Network Hours between two dates with times. I want to know how many business days and hours are between the two days.

    - 'Case Open_Date' (A1)
    - 'Case Close_Date.' (B1)
    -'Difference Time' (E1)

    Work Days = Monday to Friday
    Work Hrs = 09:00 AM to 11:00 PM (no lunch break)

    Date Received: dd/mm/yyyy hh:mm
    Date Actioned: dd/mm/yyyy hh:mm
    Response Time: d - hh:mm

    Please help me out...

    Yours sincerely