Hi

Into some free cell enter the formula
=1/(24*60)
and copy it

Select the range with your figures (minutes), and PasteSpecial>Multiply. All
selected minute entries are converted to time values. Format the selected
range as "d\d h\h m\m"


Arvi Laanemets


"M.Siler" <John.Doe@NoSpam.com> wrote in message
news:ORqAgAOKGHA.216@TK2MSFTNGP15.phx.gbl...
> If I have 43,392 minutes that is 30 days, 3 hours & 12 minutes. How do I
> format 43392 to look like 30d 3h 12m or 20 d 3:12?
>
>