Text to Time

[DJN]

I am trying to change some text into time. The format of the text is 730, 1850
This should be simple, but I am really stuck. All help appreciated.


David

 

[Jon K]

TimeValue(Left([TextString], Len([TextString])-2) & ":" & Right([TextString],2))
.

 

[DJN]

So simple! Thanks Jon

David

 

[ST4RCUTTER]

Yes Jon! Thanks. Your gift keeps on giving...