On Sun, 6 Jul 2008 20:50:31 +0200, Bret Bernever
wrote:

Hello Excellers,

This is my problem:

B2 = 10:00
D1 = 11:00

Formula in D2
=B2 & " - " & D1

Result in D2 shows
0,25 - 0,260416666666667

But it should look like this
10:00 - 11:00

How to tackle this?
Thanks in advance, bret bernever


=TEXT(B2,"hh:mm") & " - " & TEXT(D1,"hh:mm")
--ron