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
Sent from my INE-LX2 using Tapatalk
Sent from my INE-LX2 using Tapatalk