Calculate hours between start date and end date, but if no end date is provided use now
Date of Incident Date of Resolution Total Downtime (Hrs)
21/06/2024 08:3021/06/2024 11:303:0021/06/2024 10:0023/06/2024 10:0048:0025/06/2024 04:01 1091266:08
The spreadsheet is meant to calculate time between Date of Incident and Date of Resolution.
But if there’s no Date of Resolution it should use todays date and time.
However it gives a value that’s wildly inaccurate values
Date of Incident Date of Resolution Total Downtime (Hrs)21/06/2024 08:3021/06/2024 11:303:0021/06/2024 10:0023/06/2024 10:0048:0025/06/2024 04:01 1091266:08 The spreadsheet is meant to calculate time between Date of Incident and Date of Resolution. But if there’s no Date of Resolution it should use todays date and time.However it gives a value that’s wildly inaccurate values Read More
