Thread: convert seconds to hours and days
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default 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
Reply With QuoteReply With Quote