🔒 Closed Vba codes in excel macro

[Eyaa-]

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

 

[Obito_Uchiha]

may error yan boss sa baba tignan mo tapos analys

 

[Eyaa-]

Hindi wala naman bali ang output nyan is time lang lalabas. Kasi ima iminus ko yung left column to right column para makuha ko yung minute ng end of activity. Bali sa start yung gusto ko iseperate yung time and dat sa specified cell