i want a fomula to put hours in cell B1 when i input data in cell A1.can any one help me to write correct formula.
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.
i want register the hours in B1 when i input any data in A1.
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 eventCode
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.