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?