change time every minute

[Dipak543]

In column B it prints the current time whenever the value changes in column A. I am using condition like if the current time is greater than> 1 min then prints the value in column a . the problem is I want to run the code exactly at 15 sec every min like 9:15:15, 9:16:15, 9:17:15 ...somehow it increases slowly from 15 sec to 17sec to so on. I want to run a VBA macro to reset the values from 9:17:19 to 9:17:15, and 9:18:20 to 9:18:15. attaching screenshot see the second's value is increasing slowly in column B.

 

[SanjayGMusafir]

Simply out of my understanding of things the narrower the time frame, more calculations Excel has to do in background thus making system slower to respond.

 

[Logit]

Are you using a macro ... a formula ? How are you getting Excel to track the elapsed time ? Post your code and also a link to download your workbook for review.