Checking time it takes to excel to calculate

[Alexander_Golinsky]

Hi all, I need to check how long it takes to excel to calculate one formula, then another one and compare. Is it possible?? if yes then how?? Thanks in advance.

[protonLeah]

Please Login or Register  to view this content.

[Alexander_Golinsky]

this macro just checks how long it takes me to press ok button ))

[protonLeah]

Of course, that was to show you the TIMER function. A further hint: use four variables: Test1Start, Test1Duration, Test2Start & Test2Durtion. Then:

Test1Start = Timer
Your formula here
Test2Duration = Timer - Test1Start

Do the same for the second formula or code block or whatever, then subtract.