Continuous calculation of a formula
I created a €śCountdown€ť clock to an event in our company. Just the actual
date minus todays date. Anyway, it just calculates days, hours, mins, secs until an event. The problem is that you either have to hit F9 or some other cell to get it to re-calculate the formulas. I set up a macro and tied it to a €śrefresh€ť button but does anyone know how I could get the spreadsheet to calculate every second automatically or perhaps another way to add a €śCountdown clock€ť to my spreadsheet? Thanks! |
All times are GMT +1. The time now is 01:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com