Time how long a macro takes to run

One thing puzzles me though. Why do you have to divide by ? I know this is the number of seconds in a day, but why do you have to divide the number of seconds in the timer by the number of seconds in the day to convert to hh:mm:ss format?? Any ideas?? I'm not in that much of a need to know, was just wondering the logic behind it. Re: Time Calculation - How long a macro takes to run Time and dates are one format. Excel records dates and time as the elapsed number of days since a base date.

I couldn't pass up the opportunity for a bad Excel joke! I think all excel jokes are bad excel jokes So was there a previous post I should look at? Frinky, Sorry about the attempt at humor. Hey thanks guys, I got it working okay Joined Feb 17, Messages 3, MsgBox Timer - MyTimer.

I did it this way You must log in or register to reply here. Similar threads E. Replies 2 Views Question Vba line of code takes a long time to run. RogerRabbit May 9, Excel Questions. Replies 7 Views May 10, RogerRabbit Replies 0 Views Aug 27, new Solved Is it possible to have a search listbox that gives a dropdown of matches dynamically.

Replies 14 Views Aug 21, johnnyL. Question VBA code help. I can guarantee 9 times out of 10, one of my strategies will get you the answer s you are needing faster than it will take me to get back to you with a possible solution. I try my best to help everyone out, but sometimes I don't have time to fit everyone's questions in there never seem to be quite enough hours in the day! Open navigation menu.

Close suggestions Search Search. User Settings. Skip carousel. Carousel Previous. Carousel Next. What is Scribd? Uploaded by Cahaya Tambunan. Did you find this document useful?