SOLVED

# Calculate hours between start date and end date, but if no end date is provided use now

Copper Contributor

# 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

best response confirmed by JonShuard (Copper Contributor)
Solution

# Re: Calculate hours between start date and end date, but if no end date is provided use now

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.

1 best response

Accepted Solutions
best response confirmed by JonShuard (Copper Contributor)
Solution

# Re: Calculate hours between start date and end date, but if no end date is provided use now

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.