Adding a time Macro

[RodneyB]

Greetings

I am developing a call log data base in Excel 2013, I would like to add a time each time a task is completed. There are several lines in the call log and each time the task is completed I would like to click on a button for that line that will record the date and time the task was completed. I know how to do a macro but not sure how to add the date and time

Many thanks

Rodney

[alansidman]

Put a button on your worksheet. Link this code to the button.

Please Login or Register  to view this content.

When you press the button, this macro will put the time and date in what ever cell is active

[RodneyB]

Put a button on your worksheet. Link this code to the button.

Please Login or Register  to view this content.

When you press the button, this macro will put the time and date in what ever cell is active

Please excuse my ignorance but how do I link the code to the button

[alansidman]

On the developer tab.
1. Click on Design Mode
2. Insert, select form controls and select a command button
3. Click on the button
4. Assign Macro
5. Select your macro
6. Click on design mode to close this mode


https://support.office.com/en-us/art...d-9c72c843a283

[RodneyB]

On the developer tab.
1. Click on Design Mode
2. Insert, select form controls and select a command button
3. Click on the button
4. Assign Macro
5. Select your macro
6. Click on design mode to close this mode


https://support.office.com/en-us/art...d-9c72c843a283

Thank you I have added the button but now do not know how to add this script

Option Explicit

Sub Log()
ActiveCell = Now
End Sub

Normally I record a macro so I can do that I have never had to add a script so have no idea how to do that

[RodneyB]

Hi

Thank you for the help and your advice "Google is your friend" I have managed to link the code to the macro button after I adde the VBA code by following these instructions.

https://www.ablebits.com/office-addi...a-macro-excel/

I just want to add seconds now to the date and time. How do I do that

Many thanks

[alansidman]

use the format Icon on the ribbon and go to Date and make your selection

[bakerman2]

Please Login or Register  to view this content.

[RodneyB]

Please Login or Register  to view this content.

Thank you for this, I however still do not see the seconds. The column is formatted as general . Not sure what to do now

[bakerman2]

Did you try to format the column as Custom dd/mm/yyyy hh:mm:ss ?