Converting Number to Days : Hours : Minutes : Seconds

[arghyadeep_ray]

Hello All,

I need formula to convert 375350 (or any number for that matter) to be auto converted into Days : Hours : Minutes (i.e 4 Days 8 Hours 15 Minutes)

OS : WIN 7 PRO
Excel Version : Excel 2013

Thanks In Advance !!!

 

[FormR]

Hi, welcome to the forum! Here is one option:

Excel 2013
	A	B
1	375350	4 Days 8 Hours 15 Minutes
Sheet1

Cell Formulas
Range	Formula
B1	=INT(A1/86400)&" Days "&TEXT(A1/86400,"h ""Hours"" m ""Minutes""")

 

[steve the fish]

Hi. If you had your number in A1 you could try:

=TEXT(A1/86400,"dd:hh:mm:ss")

 

[FormR]

=TEXT(A1/86400,"dd:hh:mm:ss")

Only as long as the days are not > 31