"Fat Bloke" wrote:

I have a value in a spreadsheet supplied to me that reads as:
"10:08:40, 25/08/2007"
Using the LEFT function I have pulled out "10:08:40" successfully but cannot
seem format it as Time no matter what I do. I have used the Format function
and the Format Painter. Can anyone help?

Its OK, I have answered my own question. There may be a better way of doing
this but I have resolved the problem by copying the data into an Access dbase
table with a single field pre-formatted as Date/Time. I then copied that data
back into Excel - hey presto - Time Format!
There may be a better/quicker way of doing this. If so I'm still interested
but at least I can carry on with my work now.