View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger D Roger D is offline
external usenet poster
 
Posts: 1
Default How enter time DURATIONS mm:ss (not clock times), then sum?

I want to enter a column of data as time DURATION (not clock time) in mm:ss
format and then sum the total. What cell format should I select for the
duration entries (mm:ss does not work) and what calculation steps do I need
to use to sum those durations?