M
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?
format 43392 to look like 30d 3h 12m or 20 d 3:12?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
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
Custom. In the Type box, enter d"d" hh:mm
D
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
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
A
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
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
D
Dave Peterson
Well, I'll be....
Never mind!
Never mind!
Dave said: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