how to put hour in cells

What data are you placing in A1 and what results do you expect in B1. Show us some sample data with the before and after scenario. We do not have enough information from you to supply a solution.

Repeating your request does not help me to help you. Provide specific examples and not general statements. Please re-read my request for examples in post #2. Upload a sample workbook.

Place this code in the worksheet change event

Option Explicit


Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Column = 1 Then
        Target.Offset(0, 1) = Date
        Target.Offset(0, 2) = Time
    End If


End Sub

Open VBE (Alt + F11)
Click on the sheet in the left window you are working in.
Copy the code above and paste into the right window that opens
Save and close.