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 ...
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.