On Sun, 23 Oct 2005 11:30:02 -0700, "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

Just change the formatting:

Format/Cells/Number/Custom Type:

d" days, "h" hours, "m" minutes"

or use the TEXT function:

=TEXT(A1,"d"" days, ""h"" hours, ""m"" minutes""")



--ron