convert seconds to hours and days
 

in a cell i have 180000 seconds, i would like to convert this to
days:HRS:Minutes format

convert seconds to hours and days
 

In another cell enter:

=A1/86400 and format custom:
dd hh:mm:ss

should display:

02 02:00:00

--
Gary''s Student - gsnu200851


"Ranjith Kurian" wrote:

in a cell i have 180000 seconds, i would like to convert this to
days:HRS:Minutes format

convert seconds to hours and days
 

Suppose A1 = 180000

Enter the below formula in B1

=A1/86400
Right click--FormatCells--Custom format to dd:hh:mm Click OK


If this post helps click Yes
---------------
Jacob Skaria


"Ranjith Kurian" wrote:

in a cell i have 180000 seconds, i would like to convert this to
days:HRS:Minutes format

convert seconds to hours and days
 

Dividing by 60 will give you minutes, dividing by a further 60 will
give you hours, and dividing by 24 will give you days, so:

=A1/60/60/24

and format the cell as d hh:mm:ss

Hope this helps.

Pete

On May 6, 6:03*pm, Ranjith Kurian
wrote:
in a *cell i have 180000 seconds, i would like to convert this to
days:HRS:Minutes format