If these are proper times in Excel, you should be able to use its built-in
functions:
=DAY(G21) & " days, " & HOUR(G21) & " hours, " & MINUTE(G21) & " minutes"
--Bruce

"Zyzzx" wrote:

I have a column of times, gathered from (Miles/MPH)/25 to yield total time it
takes to travel a certain distance.

All are formatted [hh]:mm and sum to equal 124:29 (124 hours, 29 minutes).

I am trying to convert that to the following output:

5 days, 4 hours, 29 mins

I have tried several funtions throughout this board, but I can never equal
the correct output.

When I use - =INT(G21/7.5)&" Days, "&INT(MOD(G21,7.5))&"
Hours,"&(MOD(G21,7.5)-INT(MOD(G21,7.5)))*60&" Minutes"

I get this output (0 Days, 5 Hours,11.2162847595179 Minutes).

Nothing I have tried yields anything even close. Please help!

Thanks,

Z