SOLVED

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

Copper Contributor

Date of Incident            Date of Resolution      Total Downtime (Hrs)

21/06/2024 08:3021/06/2024 11:303:00
21/06/2024 10:0023/06/2024 10:0048: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

 

1 Reply
best response confirmed by JonShuard (Copper Contributor)
Solution

@JonShuard 

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

@JonShuard 

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.

View solution in original post