Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summing durations
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
schedules and durations | Excel Discussion (Misc queries) | |||
durations | Excel Discussion (Misc queries) | |||
Adding durations | New Users to Excel | |||
distribution of durations | Excel Worksheet Functions |