One way:

XL stores times as fractional days, so multiply by 24 hrs/day:

A1: =SUM(....) <==== 48:00
A2: =A1*24 <==== 2

Format A2 as General, or your preferred Number format.

In article ,
Joshua wrote:

I have a formula in a cell that adds up a bunch of hours and minutes and is
in the [h]:mm format, it gives me a total of 48:00

How do I get display that information, in another cell, and give me how many
days that is like, which would be 2 days