Thread
:
Entering HH:MM
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Entering HH:MM
Preformat the column as time and try this.
Right click sheet tabview codeinsert this
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column < 5 Then Exit Sub
Application.EnableEvents = False
Target = Left(Target, 2) & ":" & Right(Target, 2)
Application.EnableEvents = True
End Sub
--
Don Guillett
SalesAid Software
"Carole O" wrote in message
...
Excel 2003
I have a co-worker who enters time on a spreadsheet. She would like to
have
the time cells fomatted so when she enters 1456 it appears in the cell as
14:56. This doesn't work when I format, cell, time, 13:30. I've looked
at
format, cell, special (which would be a logical place to put something
like
this), to no avail.
TIA
CaroleO
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett