Hi Pete,
You are right about the 4 instead of 5. And I will try the left function.
Ta,
Martin

"Pete_UK" wrote in message
ups.com...
You are only taking the leftmost 4 characters instead of 5 - in your
11:30am example, your LEFT function would return 11:3, so the VALUE
function would turn this into 11:03. Try changing the parameter in your
LEFT function to 5 instead of 4. You might also think about appending
":00" to your LEFT function inside the VALUE function, so that it
converts properly to hours:mins:sec.

Hope this helps.

Pete