Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert seconds to hours and days
in a cell i have 180000 seconds, i would like to convert this to
days:HRS:Minutes format |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Difference in Days, Hours, Minutes and Seconds | Excel Discussion (Misc queries) | |||
convert seconds into days | Excel Discussion (Misc queries) | |||
countdown days,hours,minutes,seconds to a specific date | Excel Discussion (Misc queries) | |||
i need to convert seconds (ie: 17288.35111) into days, hours, min | Excel Discussion (Misc queries) | |||
Convert "Time Interval" in "hours : minutes : seconds" to seconds | New Users to Excel |