How to Concatenate Time with some operator?
 

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 with
=0.291666666666667

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

Thanks


--
changeable
------------------------------------------------------------------------
changeable's Profile: http://www.excelforum.com/member.php...o&userid=15714
View this thread: http://www.excelforum.com/showthread...hreadid=274815

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

--

HTH

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


"changeable" wrote in message
...

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 with
=0.291666666666667

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

Thanks


--
changeable
------------------------------------------------------------------------
changeable's Profile:
http://www.excelforum.com/member.php...o&userid=15714
View this thread: http://www.excelforum.com/showthread...hreadid=274815