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

[KK1234]

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.

[:) Sixthsense :)]

Try like this...

Please Login or Register  to view this content.

[john55]

try

Please Login or Register  to view this content.

[KK1234]

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

[:) Sixthsense :)]

Do right click on sheet tab and select view code and paste the below code

Please Login or Register  to view this content.

Return to excel and do double click on any of the cell of Column P and check

[KK1234]

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

[:) Sixthsense :)]

Try this...

Please Login or Register  to view this content.

[KK1234]

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

[:) Sixthsense :)]

Glad it helps you and thanks for the feedback again

[KK1234]

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

[:) Sixthsense :)]

Surely it will work

Please check once again or just post a sample file with formula and your date for fixing the issue

[KK1234]

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

[:) Sixthsense :)]

Thanks for the attachment file

Try this...

Please Login or Register  to view this content.

[KK1234]

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