Yes it does change every second but under windows 10, i can't change the clock hours and minutes temperory. I could do in windows 7.

Okay =ROUND(D3-NOW(),0) does seem to work. I will need to wait until tomorrow morning to see as I can't change the hour on my PC.