title: Excel: convert seconds to dd Days hh:mm:ss format
body: <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>