Thread: Excel functions
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Excel functions

Use SUM() function and format the total cell to CustomFormat [h]:mm:ss

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


"markwsquires" wrote:

How can I add up a column of times to give me a total expressed in hrs/mins
and secs

or alternatively simply convert a number into minutes and secs - ie 2.82 =
3m22sec ??