Not sure exactly what the data looks like, but you can manipulate all of
your data with LEFT(), RIGHT(), MID() and CONCATENATE() to get it into
hours, minutes, and seconds (if thta is even necessary). Then use the
TIME() function to put it all together. Probably not that complicated
of an issue, but that is everything you would need in a worse-case
scenario.


--
Lotus123
------------------------------------------------------------------------
Lotus123's Profile: http://www.excelforum.com/member.php...o&userid=28611
View this thread: http://www.excelforum.com/showthread...hreadid=487462