convert seconds to hours and days

[Ranjith Kurian]

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

 

[Gary''s Student]

In another cell enter:

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

should display:

02 02:00:00

 

[Jacob Skaria]

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

 

[Pete_UK]

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