View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Summing durations

If you use the time format, you can simply sum these, just make sure you
format the result as [h]:mm:ss to allow for more than 24 hours.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Alex" wrote in message
...
I am trying to set up a worksheet with all of the music stored on my
computer, with the total duration listed. Is there any way to set up the
SUM() function so that it returns this value, or do I need to use a

different
function?