3 Replies Latest reply: Nov 17, 2012 5:21 PM by Jerrold Green1
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
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
Level 1 (0 points)

Ah that's great, thanks so much.

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

Thanks for the feedback.

Jerry