SumIF and time. Going back to 1 when more than 24 hours are calculated

[Joe D]

Hello all. I have a spreadsheet that automatically calculates downtime based off of military time entered into two other columns on a corresponding tab. I use a SUMIF function below to come up with a total downtime for each server in all columns "E", and add the downtime together from all columns "D". Spreadsheet tab is called Incidents.

=SUMIF(Incidents!E:E,A53,Incidents!D:D)

It works great, but I am now discovering an issue that once a total accrued down time exceeds 24 hours, the total downtime calculated by my SUMIF is bringing the time down to 1. So, 24:53 of total downtime is being expressed as 1:53, which skews some subsequent columns that I have calculating uptime percentage.

Can anyone assist with being able to keep my downtime from reducing down to 1 after 24 hours is exceeded?

Thanks so much in Advance.

Joe d

 

[Norie]

Joe

How have you formatted the cell with the formula in it?

If the result may exceed 24 hours you should format it as [h]:mm.

 

[Joe D]

Norie, God, I am guilty of classic overthinking! Thank you so much for the clarity. I got so wrapped up in the code that I didn't even think about the column format.

Thanks again!