Currently Being ModeratedNov 17, 2012 5:06 PM (in response to Pincushion)
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
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.
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: