Timer function needs improvement
Oh wise ones,
I use the following function to indicate the time a cell "D2" is less than 350. I have a macro that refreshes (recalculates) D2 every 2 seconds. It works, but is not very accurate. How can I convert this function, maybe vba, to keep track in real time how long D2 is less than 350? I'm guessing the overhead to calculate and update a cell takes a wee bit longer than 2 seconds. I6 contains =IF(D2<350,I6+2,0) J6 contains =I6/60 K6 contains =INT(J6) 'minutes L6 contains =(J6-K6)*60 'seconds Thanks, Mike |
All times are GMT +1. The time now is 05:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com