guys pa help naman ako. Im coding a TAM tools( Time and Motions Tools) in Excel macro (VBA Codes). Gusto ko ihiwalay yung date at time sa ibang cell kung baga separated sila kapag pinindot ko na yung Buttons this is my codes.
Sub Start_time()
Range("F" & ActiveCell.Row).Select
ActiveCell.Value = Time()
End Sub
Sub end_time()
Range("G" & ActiveCell.Row).Select
ActiveCell.Value = Time()
Range("H" & ActiveCell.Row).Select
ActiveCell.Value = ActiveCell.Offset(0, -1).Value - ActiveCell.Offset(0, -2).Value
End Sub
example. si A1 gagawin kung date si A2 naman is Time kapag ni click ko na si command button
thanks sa papasnsin
Sub Start_time()
Range("F" & ActiveCell.Row).Select
ActiveCell.Value = Time()
End Sub
Sub end_time()
Range("G" & ActiveCell.Row).Select
ActiveCell.Value = Time()
Range("H" & ActiveCell.Row).Select
ActiveCell.Value = ActiveCell.Offset(0, -1).Value - ActiveCell.Offset(0, -2).Value
End Sub
example. si A1 gagawin kung date si A2 naman is Time kapag ni click ko na si command button
thanks sa papasnsin