View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PCLIVE
 
Posts: n/a
Default Displaying seconds in hh:mm:ss format

I've got a cell with the total number of seconds in it.

A1 contains the number: 3,157

This number represents seconds. Is there a format or function that will
display this in hours-minutes-seconds (hh:mm:ss)?

Thanks,
Paul