Hello I am trying to use the timer function in excel without much sucess, what i want to do is put a button in the spreadsheet, when it is clicked a timer is then activated. Another button is then clicked to stop the timer then the time taken results are displayed in another cell. Any help would be great, thamks Paul

Hi Paul Best way I can think of doing this is to declare a public Date variable within the spreadsheet. When the first button is clicked, have some VBA assign the current system time to the variable. When the second button is clicked, have it compare the new current system time to the variable. Two things to note: 1) You'll probably also want a boolean switch that tells the second button whether the first has actually been pressed 2) I sometimes have problems with the system time assignation to Date variables, and so if "to the nearest second" is good enough, I usually assign the seconds, minutes and hours out to integers Hope that helps Tom