How to Concatenate Time with some operator?

C

changeable

Hi, I tried to do some concatenate using this two value:

A B
= 7:00:00 using =concatenate(A1,B2)
Click to expand...

i am expecting the result would be >=7:00:00 but it come out wit
=0.291666666666667
Click to expand...

How can i do the concanate by remaining the value of the TIME.

Thank
 
B

Bob Phillips

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

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top