|Is the time always proceeded by the word site?|
Is the time always 4 digits hyphen 4 digits?
Will the time always contain a hyphen?
What I'm looking for is something that's consistent so that a User Defined Function (UDF) or macro can be written to search the string for the "time string" (which is really a text string) and extract it from the full string.
For example, if we we can determine where it starts and we know that it is always 9 characters long, we can extract it.
Any details that that describe some sort of consistency would help.
Keep in mind that Excel was never intended to work well with text, so you're not going to be able to this with a built in Excel function.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.