Appel Malade
New member
When a log only stores clock times without the date, any call raised before midnight and answered after it gives a negative duration, and Excel displays a row of hash signs instead of the delay. The simplest fix is to wrap the subtraction in MOD, with the end time minus the start time as the first argument and one as the divisor: since Excel stores a full day as one, MOD returns the correct positive fraction of a day. Format the result cell as [h]:mm:ss so that long delays are not cut back to the clock value. If the export contains full date-time stamps, prefer a plain subtraction of the two stamps, because MOD would silently hide a gap longer than twenty-four hours. To get the delay in minutes for averages or thresholds, multiply the result by the number of minutes in a day; a frequent mistake is to use MINUTE(), which only returns the minute part of the time. Also check that the exported stamps are real times and not text: convert them with TIMEVALUE or DATEVALUE first, otherwise the subtraction returns #VALUE!.