Combine cells with numbers into string

[jonasbirk]

Hi!

I have two cells, A1 and A2 where A1=16 and A2=10.
I would like a simple way to create a cell that is text and says 16:10 (time). How do I program this?

Thanks!

Jonas

[zbor]

¸Try this:

=TIME(A1,A2,)

[Richard Buttrey]

Hi

=TIME(A1,A2,0)

formatted as appropriate, e.g. "hh:mm"

[jonasbirk]

Sorry, that doesn't work. Excel says it's the wrong format. (I have Office 2003).

[Richard Buttrey]

Hi,

Works fine for me in all versions of Excel including 2003. Are you sure your A1 & A2 cells are numbers. Test them with =ISNUMBER(A1) & ISNUMBER(A2)

Upload your workbook if you still have a problem.

Regards

[jonasbirk]

How do I upload a file here?

[jonasbirk]

I solved it! Language differences =)