Problem using time and formulas with a form

**D3Pratt** · 03-27-2009, 10:15 AM

I want to click a command button on a form and populate a cell with a time stamp in HH:MM format, AND have it show in a text box next to the button.

Well, actually two buttons, one for start, one for stop.

Then I want to have the worksheet calculate the elapsed time and show that on the form in the same HH:MM format.

The problems I'm encountering:

1)The form overwrites the formula the way I have it set up.
2)I can't get the time to be shown on the form in the HH:MM format

**D3Pratt** · 03-27-2009, 05:01 PM

Been thinking about this all day

I think the solution to problem 1 is to have a macro execute the same function I was doing as a formula, then write that value to a cell that the Text Box will just mirror.

Now, I need to figure a way to include that macro with the execution of the second (Stop) Button.