Auto Refresh

I have a worksheet that uses the NOW function to subtract a set time from the current time. This lapse is then used to generate a production output. I have put a refresh button on the sheet which updates the current date/time cell by running the now function when it is pressed. Is there a way to get excel to continually update the cell with real time.

Any help greatly appreciated

Roy