|Mike, All the TIME and DATE are in one cell.|
Humar, THANKS a lot, your function works great. Not having used RIGHT, LEFT, LEN and FIND functions before. It took a while to understand how you were getting the time difference between two data points. Once understand, I simplified the function furter
11:54:23:11 - 23 MAY 10
11:54:38:11 - 23 MAY 10
=DATEVALUE(RIGHT(A1,9)) + TIMEVALUE(LEFT(A1,8)
Again Mike and Humar thank you much, it was very helpful.