Thread: 3.10 PM to 24 hour time please ( 1510 )
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey
 
Posts: n/a
Default 3.10 PM to 24 hour time please ( 1510 )
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.
Reply With QuoteReply With Quote