Excel: convert seconds to dd Days hh:mm:ss format
<p>I want to convert seconds into dd <em>days</em> hh:mm:ss.</p>

<p>This is what I have:
I have a cell (A1) with value 457003 and in Cell B1 I am doing =Text(A1/(24*60*60),"dd hh:mm:ss" and it is returning 05 06:56:43.</p>

<p>What i am looking for is 05 <strong><em>days</em></strong> 06:56:43.</p>

<p>Please help!!</p>

<p>Thank you</p>