Combining = & " as additional text with another Cell Reference..?

[Ourkid123uk]

Hi all!

In the below Example i wont use quotation marks for my Cell Value in Column N as this may be confusing.

I have a Values of Times in Column N for example;

02:05:00

In Column M i want it to Reference the Cell to its immediate right and add some characters to that value achieve the result of

="=02:05:00

Im trying but its getting confused as i'm entering double quotes and its thinking i'm trying to achieve something else.

Any help appreciated

[Jonmo1]

The problem is likely that your value is actually a TIME value.
That is stored as a plain old decimal number in a cell... Time is stored as a decimal value, a portion of 1 day.
So 2 hours and 5 minutes is actually about 1/12th of a day (+ the 5 minutes)
In decimal value it's 0.0868055555555556

So when you reference that cell with a concatenate operation ( & ), apply the text function to display the hours.

Try
="="&TEXT(A1,"hh:mm:ss")

[Ourkid123uk]

Thanks Jonmo!

This helped me fix another problem so thank you!

For the above i actually used ="""" to escape out the double quotes and use it as a character within my text.

Your formula has helped all my previous data/time troubles so thank you.

[Jonmo1]

You're welcome.