format minutes to days hours & minutes

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?

=A1/24/60 (Time is stored as a fraction of a day), format>Cells>Number tab,
Custom. In the Type box, enter d"d" hh:mm

--
Kind regards,

Niek Otten

"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?
>

I don't think you'll be able to just format the cell to get that.

But with 43392 in A1, I put this in B1:
=INT(A1/60/24)&"d " & TEXT(MOD(A1/60/24,1),"hh\h mm\m ss\s")

And got:
30d 03h 12m 00s



"M.Siler" wrote:
>
> 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?

--

Dave Peterson

Well, I'll be....

Never mind!


Dave Peterson wrote:
>
> I don't think you'll be able to just format the cell to get that.
>
> But with 43392 in A1, I put this in B1:
> =INT(A1/60/24)&"d " & TEXT(MOD(A1/60/24,1),"hh\h mm\m ss\s")
>
> And got:
> 30d 03h 12m 00s
>
> "M.Siler" wrote:
> >
> > 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?
>
> --
>
> Dave Peterson

--

Dave Peterson

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?
>
>