Converting a Number to Time
 

Hi Team

In an effort to speed up data entry, I would rather the user ( namely me at this point ) be able to add a number and have it converted to it's time equivalent:

So, if I enter:
515. Convert it to 5:15
1415. Convert it to 14:15, etc.

I would like to insert into my existing Worksheet_Change code:
If Not Intersect(Target, Range("C3:C43")) Is Nothing Then
If Target.Cells.Count 1 Then Exit Sub

Select Case Target.Column
Case 3
If Target.Value = "YARD" Or Target.Value = "C0654" Then
Target.Offset(0, 7).Select
Else
Target.Offset(0, 1).Select
End If
Case 8
Target.Offset(0, 2).Select
Case 10

Target.Offset(0, 1).Select
End Select
End If


I found the following code, which does what I need if I trigger it manually, but won't trigger inside the Change Code.