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)

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

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top