Know how long a service is impacted with a formula in an excel report

It is important to know how long the service has been impacted by an outage, it is one of the indications to know in which area I need to improve the quality and the satisfaction of the customers.

formula

 

When I use the formula ?

I need to know how many minutes or hours the service was impacted so if I have the end time, I know how long the issue lasted and if the issue is not yet resolved, I know how long the service is still impacted

 

How to use the formula ?

The formula in this topic is with ";" so depending of the operating system of your PC, the formula should have "," instead of ";".

 

How are the formulas ?

=IF()

=NOW()

=IF(B2="";NOW()-A2;B2-A2)

So if in my cell B2 “end time” is empty B2="" because the issue is still open, I ask the formula NOW()-A2 to show me the duration of the ongoing issue in which the cell A2 is “start time”. If not empty, I ask the formula to show me the duration of the incident B2-A2. To see more than 24h, format the cell with the "custom" option by putting: [h]:mm

Interesting Management