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