>Your solution is the closest so far, it returns correct results for quasi military time with a ":". However, it doest work with real military time.

Yeah, and I wasn't really specific about the "military time" label. My data is in the "99:99" format. Hugo's solution worked great for what I needed it for.