Thread: Displaying seconds in hh:mm:ss format
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid
 
Posts: n/a
Default Displaying seconds in hh:mm:ss format
Paul,
you need to divide by 86400. The format you seek can be found in
Format|Cells..., under the Number tab. Choose a Time format.

HTH
Kostis Vezerides

Reply With QuoteReply With Quote