ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Summing durations (https://www.excelbanter.com/excel-programming/316035-summing-durations.html)

ALEX

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?

Bob Phillips[_6_]

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?





All times are GMT +1. The time now is 05:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com