Calculate elapsed time

Hi Syndicate_Admin ,

The logic of your calculation seems to be that
when closing date is empty, elapsed time = current date - opening date.
When not empty, elapsed time = closing date - opening date.
Based on my understanding, here is the data I created from the sample you provided.

Please try the following code to create Calculated Column.

TIEMPO(dd, hh:mm:ss) = 
VAR Sec =  IF('Table'[FECHA CIERRE] = BLANK(),   
               DATEDIFF('Table'[FECHA APERTURA], TODAY(), SECOND),
               DATEDIFF('Table'[FECHA APERTURA], 'Table'[FECHA CIERRE], SECOND)
)
VAR Days = INT(Sec / 86400)
VAR Hours = INT(MOD(Sec, 86400) / 3600)
VAR Minutes = INT(MOD(Sec, 3600) / 60)
VAR Remainder = MOD(Sec, 60)
RETURN FORMAT(Days, "00") & ", " & FORMAT(Hours, "00") & ":" & FORMAT(Minutes, "00") & ":" & FORMAT(Remainder, "00")
                        

Result is as below.

Please correct me if I misunderstood your needs.

Best Regards,
Yulia Yan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.