Seconds to days, hours, minutes

R

randz77

New member
Joined
Oct 26, 2015
Messages
14
Reaction score
0
Points
0
Location
Philippines
Excel Version(s)
2013
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
723dc7501e91fb84b49ccaca1c600176.jpg


Sent from my INE-LX2 using Tapatalk
 
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.
 
Thanks alansidman. The formula works in other cells. not sure why it's not working consistently even after restarting excel.


alansidman said:
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.
Click to expand...
 
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.
 
Also please do not quote entire posts unnecessarily.
Use the "Quick Reply" instead
 
Try:
Code: 
=INT(A1/86400) & " days " & TEXT(MOD(A1/86400,1),"hh:mm:ss")
 
You must log in or register to reply here.
Back
Top