Sum of days between dates in Excel

Question

I have a column where its cells are formatted as "dd hh:mm:ss"

When I'm going to do the totaling of the lines and the number of days "no" exceeds 31, the sum works perfectly, but when the sum of days exceeds 31, Excel considers that we have changed the month and the value of days is reset.

Command:

=SUM(B1:B2)

Result:

           sum of dates                       sum of dates
      "no" exceeded 31 days                 exceeded 31 days

       A         B                        A         B
1            15 00:00:12             1          15 00:00:12
2            16 01:39:48             2          19 01:39:48
             -----------                        -----------
    Total    31 01:40:00                Total   05 01:40:00 ----> here i need it to be "34 01:40:00".

How to make Excel continue summing correctly after days count is greater than 31? ex: 32, 33, 34, 35...

Note:
The cell that will count the total value, which must always be in the format "dd hh:mm:ss" because I will use it in another calculation in my table.

Answer 1

Try adding [ ] around the DD, i.e., [DD] for the formatting.

EDIT: Apologies, I'm away from my PC (on a Chromebook at the moment), so I couldn't verify. It seems I mistakenly recalled the similar usage for TIME datatype digits, such as [hh]; however, it seems the d in date data types does not have the equivalent functionality.

Instead, what you can do is use a formula like this:

=text(INT(A3),"#,#00")&" "&TEXT(A3,"hh:mm:ss")

Due to the nature of how Excel processes time, you can treat the number of days as an integer, then concatenate the remainder of the time digits as text. Both of these can be formatted using the TEXT() function.