Text to time challenge

[sachavez]

Looking for a VBA solution to convert this format "00.00.00" to time.

So 01.30.00 would be 01:30
and 13.30.00 would be 13:30

The trailing 00s have no value and could be eliminated.

I would first select the range, and then execute the macro.

Thanks in advance

 

[shg]

Sub sachavez()
  Selection.Replace ".", ":"
  Selection.NumberFormat = "[hh]:mm"
End Sub

 

[sachavez]

Sub sachavez()
  Selection.Replace ".", ":"
  Selection.NumberFormat = "[hh]:mm"
End Sub

Super! Appreciate you helping a fellow Texan! Code works like a champ!

Steve

 

[shg]

You're welcome.