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.
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
When you are managing a team, “how to be a good manager” is the “must”...
As manager, I am doing many reports, even when I was an ITIL consultant, I still needed to do many reports...
ITIL V3 is going to be obsolete...
Managing an IT service when I start a new company is not an easy task, particularly true, if the service...