Command button to populate todays date and time in next free row

Hi all,

I am using this code to populate todays date and current time in column 1 i.e. A

But I want it to populate the same in next free row. Currently it only populates in A1

Any help please???
Regards

Please Login or Register  to view this content.

Hi Sixthsense and John,

It works like magic. I have clicked * for both to express my gratitude.

I have similar issue in column 'P' in the same sheet.
I have provided the similar click button , but it populates date and time in the first available free row.
But now I want to modify code to populate date and time NOW=() in the cell in column P which is highlighted with mouse.
Is it possible?
Regards

Hi Sixthsense,

Mate it works like a magic. Thanks. i have clicked * again for you.

Before I close this one just a last question.

I use formula to check difference between two dates.

Please Login or Register  to view this content.

However it does not calculate time difference.
Do you have any suggestion how can i do it so that A-P will indicate e.g. Days..... Hours : Mins 00:00.

many thanks my friend

Regards

Hi Mate,
Perfect solution.
Great work.
Thanks very much. Apology for a delayed reply as I had to go for work.
Thanks again
regards

Hi again,
Apology to reopen the thread.
Ran into slight issue.

It stopped doing its work. Now it does not subtract time and the days calculation is not as expected.
E.G.

Please Login or Register  to view this content.

Something is missing
Regards

Hi Mate,
I have attached the file.
Thanks again
Regards

Hi,
Now it is is a perfect as ever.
But is only calculates hours . Min are still an issue. So I modified your formula as below and now it works perfectly without any fault.
=IF(OR(A2="",P2=""),"","["&DATEDIF(MIN(A2:P2),MAX(A2:P2),"D")&" Days] "&TEXT(MOD(P2-A2,1),"HH:MM:SS"))

Great help.
I have clicked *
Many thanks.
I have closed the thread.
Regards