Thread: Seconds to days, hours, minutes

1. Seconds to days, hours, minutes

So I have 3401388 seconds in cell A1, I'm trying to convert it to dd:mm:ss using the formula text(A1/86400, "dd hh:mm:ss") but its only giving me 8 days, 08:49:48, when it should be around 39 days.. Not sure if I'm missing something Sent from my INE-LX2 using Tapatalk  Reply With Quote

2. Here is how I would calculate

Data Range
 A B C D E F G 1 Minutes Hours Days Hours Minutes Seconds 2 3401388 =A2/60 =B2/60 =C2/24 =(D2-INT(D2))*24 =(E2-INT(E2))*60 =(F2-INT(F2))*60

and then concatenate the integer portions of D, E, F and G appropriately.  Reply With Quote

3. Thanks alansidman. The formula works in other cells. not sure why it's not working consistently even after restarting excel. Originally Posted by alansidman Here is how I would calculate

Data Range
 A B C D E F G 1 Minutes Hours Days Hours Minutes Seconds 2 3401388 =A2/60 =B2/60 =C2/24 =(D2-INT(D2))*24 =(E2-INT(E2))*60 =(F2-INT(F2))*60

and then concatenate the integer portions of D, E, F and G appropriately.  Reply With Quote

4. We cannot test and manipulate a picture. If you will upload your workbook then I am sure that a solution can be found after some testing.  Reply With Quote

5. Also please do not quote entire posts unnecessarily.  Reply With Quote

6. Try:
Code:
`=INT(A1/86400) & " days " & TEXT(MOD(A1/86400,1),"hh:mm:ss")`  Reply With Quote

7. this thing works.. thanks p45cal  Reply With Quote Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•