3 Replies Latest reply: Nov 17, 2012 5:21 PM by Jerrold Green1
Pincushion Level 1 Level 1 (0 points)

Hi guys, I'm really sorry for this elementary question – I did try to find out the answer by myself but I can't find it. This is the problem. I have a column of durations in seconds, and I want to know the average of those times in minutes. Why does

 

=DUR2MINUTES("AVERAGE(J4:J9)s")

 

not work? It says syntax error. I don't know what the syntax is supposed to be for using one function inside another, but =SUM(AVERAGE(J4:J9), 12) and =DUR2MINUTES("12s") both do work, so I thought I was being consistent.

 

 

I know I can just put the average of the seconds in one cell and change it into minutes in the next, but I can't imagine it can't be done directly.


Numbers, Mac OS X (10.7.5)
  • 1. Re: Function within a function
    Jerrold Green1 Level 7 Level 7 (28,995 points)

    Pincushion wrote:

     

    Hi guys, I'm really sorry for this elementary question – I did try to find out the answer by myself but I can't find it. This is the problem. I have a column of durations in seconds, and I want to know the average of those times in minutes. Why does

     

    =DUR2MINUTES("AVERAGE(J4:J9)s")

     

    not work? It says syntax error. I don't know what the syntax is supposed to be for using one function inside another, but =SUM(AVERAGE(J4:J9), 12) and =DUR2MINUTES("12s") both do work, so I thought I was being consistent.

     

     

    I know I can just put the average of the seconds in one cell and change it into minutes in the next, but I can't imagine it can't be done directly.

    Hi Pin,

     

    Your problem is not with the nesting of functions, it is, as the error tells you, a syntax error. You are attempting to concatenate the average of a range of numerical values with the text character "s" and you haven't used the proper contatenation rules. A properly functioning equivalent would be:

     

    =DUR2MINUTES(AVERAGE(J4:J9)&"s")

     

    Regards,

     

    Jerry

  • 2. Re: Function within a function
    Pincushion Level 1 Level 1 (0 points)

    Ah that's great, thanks so much.

  • 3. Re: Function within a function
    Jerrold Green1 Level 7 Level 7 (28,995 points)

    Thanks for the feedback.

     

    Jerry