View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default How to sum hours, mins, secs (00:00:00)?

Dave , do the normal sum itself; but format the total cell to [h]:mm:ss

Right clickFormat CellsCustom

If this post helps click Yes
---------------
Jacob Skaria


"Dave" wrote:

Hi, does anyone know how this is possible?

Thanks