format minutes to days hours & minutes

[M.Siler]

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?

 

[Niek Otten]

=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

 

[Dave Peterson]

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

 

[Arvi Laanemets]

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

 

[Dave Peterson]

Well, I'll be....

Never mind!

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