Converting text to time

[latex88]

How to convert this string of text that is formatted yyyymmddhhnnss to hh:nn?

I can do the mid function to extract the hhnn out, but have a hard time with the rest.

 

[pwbrown]

http://stackoverflow.com/questions/...nverting-string-to-date-using-format-or-cdate

This should solve your problem.

 

[latex88]

Thanks for pointing me to the right direction.

I ended up using below. The function returns something like 12:12:44 PM.
=TimeSerial(Mid([TimeStamp],9,2),Mid([TimeStamp],11,2),Mid([TimeStamp],13,2))

I wish I don't have to show the seconds, but I believe the function requires it.