Referencing cells into one cell

[Jedit]

I am trying to reference two cells and have both values show up in one cell.

I would like for cell C1 to say 10:54:13 to 10:56:13. I attempted to write =A1 to =A3 inside cell C1 but I always get an error.

What is the macro I need to write in order to make C1 show values of A1 and A3 with the word 'to' in between the two values?

I am trying to determine a range and will be doing this throught my entire workbook.

Thanks for any help you can provide me.

Jedit

See Table below for a visual reference:
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]10:54:13[/TD]
[TD].0352[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]10:55:13[/TD]
[TD].0462[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]10:56:13[/TD]
[TD].571[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Jonmo1]

You can use the & operator for that

=A1&" to "&A3

Now, if A1 and A3 are true time values, you'll need to include the TEXT function as well.
=TEXT(A1,"hh:mm:ss")&" to "&TEXT(A3,"hh:mm:ss")

 

[Jedit]

Thank you very much for the help. I knew there was an operator I was forgetting.