R Ranjith Kurian May 6, 2009 #1 in a cell i have 180000 seconds, i would like to convert this to days:HRS:Minutes format
G Gary''s Student May 6, 2009 #2 In another cell enter: =A1/86400 and format custom: dd hh:mm:ss should display: 02 02:00:00
J Jacob Skaria May 6, 2009 #3 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
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
P Pete_UK May 6, 2009 #4 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
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
