Network days calculation issue

HI i have 2 columns of data which is created date and resolved date both formatted as dd-mm-yyyy-h:mm the MTTR column is formatted as dd:hh:mm and the formula used is =(NETWORKDAYS(R146,S146)-1)*("17:00"-"8:00")+IF(NETWORKDAYS(S146,S146),MEDIAN(MOD(S146,1),"17:00","8:00"),"17:00")-MEDIAN(NETWORKDAYS(R146,R146)*MOD(R146,1),"17:00","8:00") the calculation made does not seem to provide an accurate MTTR in days hours mins. See example attatched, I also have a yes/no formula based on specific time values if the MTTR cell is less than or greater than say 10 minutes or xx hours. again cant seem to get itworking correctly. any help greatly appreciated. This is to find how long it is taking us to resolve incidents/requests

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

As you are new here I will add it for you this time https://chandoo.org/forum/threads/ne...n-issue.41621/

apologies i will read

The calculation does look ok, what is wrong with it you think?

You are calculating the number of business days it took right?
can you show what the outcome should be of one of your examples, so where it goes wrong?

When you look at the mttr calculation in days/hours etc the calculaiton does not look correct. when you look at the created date and then the resolved date then the mttr values they dont match up. the first one should show over 6 months of days.

Created Time Resolved Time MTTR
20-07-2018 13:57 14-03-2019 11:45 03:06:48
11-03-2019 21:22 25-03-2019 1:57 03:09:00
14-01-2019 15:37 26-03-2019 12:44 19:00:07
12-03-2019 16:27 18-03-2019 10:56 01:06:29
06-03-2019 11:01 13-03-2019 10:25 01:20:24
21-02-2019 9:40 05-03-2019 14:03 03:04:23
08-12-2017 9:34 21-03-2019 14:06 04:10:32
12-02-2019 4:45 26-02-2019 21:04 04:03:00
22-03-2019 10:41 27-03-2019 9:52 01:02:11
28-02-2019 8:35 11-03-2019 11:23 02:17:48
28-02-2019 14:20 12-03-2019 6:58 02:17:40
28-02-2019 17:12 12-03-2019 10:52 02:17:52
06-05-2019 14:00 06-05-2019 14:05 03:17:52

Please post sheets as you did before. It is much easier to understand and work with

should be attached now the link button in the thread does not allow me to upload fromwithin the message

No it does not work at the moment. I see you found how to post. Great !