I am using Excel to help me record responses to some performance tests I give. In doing this, I have to record start and stop times, in seconds, then calculated the differences. To date, I have entered the minute and second manually, with Excel calculating the differences. It would be much better if I could create some icon or macro to click the start and stop times, without referring to a clock. I have played with entering the time by using CTL+SHIFT+;. I format the time in hours, minutes and seconds. Each time, Excel enters 00 for the seconds, rather than the actual seconds. I need the exact seconds, and don't know how to do this. Can someone help me?

Simplest way through a macro is to use sub writecurrenttime() selection.value = now() end sub This code will write the time now (including the seconds part) in the selected cell. There are other ways of accomplishing it (using userforms with start and stop buttons, etc)