Or maybe

=TEXT(SUBSTITUTE(A1,".",":"),"HMM")


"JE McGimpsey" wrote in message
...
One way:

=--SUBSTITUTE(A1,".",":")

Format as hhmm

In article ,
Steved wrote:

Hello from Steved

Could I have a formula to acheive the below please.

Below is "Text"
3.10 PM to 1510

Thankyou.