=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