SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table Tabela
(
  status_0 varchar(10), relog_0 datetime, 
  status_1 varchar(10), relog_1 datetime, 
  status_2 varchar(10), relog_2 datetime, 
  status_3 varchar(10), relog_3 datetime
);

insert into Tabela values
(
  'ATIVA', '19000101 17:14:31', 
  'ATIVA', '19000101 03:25:57',
  'CANCELADA', '19000101 20:00:00',
  null, null
);

select
      convert
        (varchar(10), 
         DATEDIFF
           (DAY, 
            0, 
            iif(status_0 = 'ATIVA', relog_0, 0) + 
            iif(status_1 = 'ATIVA', relog_1, 0) + 
            iif(status_2 = 'ATIVA', relog_2, 0) + 
            iif(status_3 = 'ATIVA', relog_3, 0)) * 
         24 + 
         DATEPART
           (HOUR, 
            iif(status_0 = 'ATIVA', relog_0, 0) + 
            iif(status_1 = 'ATIVA', relog_1, 0) + 
            iif(status_2 = 'ATIVA', relog_2, 0) + 
            iif(status_3 = 'ATIVA', relog_3, 0))) + 
      RIGHT
        (convert
           (char(12), 
            iif(status_0 = 'ATIVA', relog_0, 0) + 
            iif(status_1 = 'ATIVA', relog_1, 0) + 
            iif(status_2 = 'ATIVA', relog_2, 0) + 
            iif(status_3 = 'ATIVA', relog_3, 0),
            114), 
         10) as Soma
from Tabela

Soma
20:40:28:000