Union,

This looks like a time value format that you want so in Sheet!2A1

=(Sheet1!A1&":"&Sheet1!A2&":"&Sheet1!A3)*1

This returns 0.136064815. Just format the cell as h:mm:ss to achieve
the desired look of 3:15:56. This will enable you to use the number in
calculations. If it is ok to be in text then this will be ok with
General formatting.

=Sheet1!A1&":"&Sheet1!A2&":"&Sheet1!A3



Does that help?

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=534625