Combining a SUM & TEXT formula

[Halifax81]

I have the following formula

=TEXT([B]'Non Productive Aux'!B25[/B]/86400,CHOOSE(MATCH([B]'Non Productive Aux'!B25[/B],{0,60,3600},1),"hh:mm:ss","hh:mm:ss","[hh]:mm:ss"))

which I now want to amend and insert the following into the formula above replacing the bits I have made bold

=SUM('Opmis MPP Data'!C7:C27)

Only problem is no matter what way I do it I fail miserably anyone know the correct way to insert this into the formula to make it work without throwing up error messages?

Ive not got excel on this machine so it won't be until the morning now until I can try again

Thanks in advance

 

[barry houdini]

Should just be a straight replace, i.e.

=TEXT(SUM('Opmis MPP Data'!C7:C27)/86400,CHOOSE(MATCH(SUM('Opmis MPP Data'!C7:C27),{0,60,3600},1),"hh:mm:ss","hh:mm:ss","[hh]:mm:ss"))

 

[Halifax81]

Thats what I thought when I was doing the sheet earlier, mind you I had, had enough by the time I was doing this so maybe I just totally messed it up and didn't realise, will try again tomorrow with a fresh head

Thanks