A cell with text and a formulae, then more text

[Mabocat]

I have a cell N40 with this info
After MG1 arrives at 3:30, then advise

What I would like is the 3:30 refer to a cell N33 which has a time based on a main cell N31 elsewhere
eg main cell N31 has 3:15, secondary cell N33 has this formulae =N31+TIME(0,15,0) which shows as 3:30 which is used in my sentence above so that if N31 is altered, both N33 & the time info in cell N40 also changes.

any ideas please?

Ron

<colgroup><col width="42"></colgroup><tbody>
</tbody>

 

[fhqwgads]

="After MG1 arrives at "& N33 & ", then advise"

EDIT: sorry that might now work because it's referring to a cell with time in it

EDIT EDIT: try this

="After MG1 arrives at "& TEXT(N33,"H:MM") & ", then advise"

 

[Mabocat]

perfect thank you

Ron

 

[Mabocat]

further to my question - how do I make the last bit of text after the "& TEXT(N33,"H:MM" formula , bold in format ?

 

[Scott Huish]

You can't make part of a cell bold with a formula. It can be done with VBA, but it would have to convert it to text and you would lose the formula.

 

[Mabocat]

Thanks, I thought that would be the answer.