Forum Discussion
Solved
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:30 | 21/06/2024 11:30 | 3:00 |
| 21/06/2024 10:00 | 23/06/2024 10:00 | 48:00 |
| 25/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
Let's say Date of Incident is in A2 and down, and Date of Resolution is in B2 and down.
In C2:
=IF(A2="", "", IF(B2="", NOW(), B2)-A2)
Format as [h]:mm then fill down.
Let's say Date of Incident is in A2 and down, and Date of Resolution is in B2 and down.
In C2:
=IF(A2="", "", IF(B2="", NOW(), B2)-A2)
Format as [h]:mm then fill down.
