to add a text to a calculated cell

[jimriordan]

Hello, i am trying to add a few cells together: =sum(d4:d9) and with that result i would like to have text added to say something like "minutes". So the end result would say d4=10 + d9 =10 so sum of d4:d9 =20 and I would like the text with the results to equal "20 minutes". Is that possible to add a text to that type of calculation?

[Fluff13]

How about
=SUM(D4:D9)&" Minutes"

[Fluff13]

Alternatively use a custom format
#,##0" Minutes"

[jomaor1]

You can also be more elegant and make:

Please Login or Register  to view this content.

Cheers!

[jimriordan]

That worked! Thank you. I had tried something similar to that, but i had the syntax all wrong.

[jimriordan]

Thank you, that worked! I had tried something similar to that, but had the syntax wrong.

[Fluff13]

You're welcome & thanks for the feedback