How to subtract Time Values contained in Labels on a userform - Time Elapsed Live Clock

Hi All,

Fairly new to the forum here, although I have been using similar forums for years to help self-learn Excel functionality and recently some VBA.

I've deduced a good bit to get started here but I feel it is something relatively simple required to just get me over the line with what I want to achieve. Again I've trawled the internet trying to find a simpler way of just "displaying a time elapsed between clicking of each button timer" but this is the closest I've yet to get.

Basically I have a user form designed for inputting details of calls received by a Helpdesk. One of the things I want to achieve is a running clock of how long the call has lasted.

To achieve this users must click - a Button (Button1) which will:
1. record the start time of the call and place in caption of Label14 (not working)
2. display a running clock in Label 12 based on the "Time" functionality of VBA (working fine-code below)
3. display the amount of time elapsed so far on the call by simply subtracting 2(above) from 1(above) and placing result in Label13 (not working)
Users must then click another button (Button2) which will input all the data from the form onto an excel sheet in the background (working)

Again I am using the code to refresh every second for a live timer in both respects, but if there is a simpler way I've yet to find it.

If anyone can help me with this it would be greatly appreciated. Code below:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks for you help Bernie, however when I run the form and click Button 1 I am now getting the following error:

"Compile error:
Method or data member not found"

With the "Private Sub CommandButton1_Click()" highlighted yellow
and the ".Value" in "Me.Label13 = Format(TimeValue(Label12.Value) - TimeValue(Start_time.Value), "hh:mm:ss")" highlighted in blue.


I was getting this error to begin with I think....

Anybody shed some light?


Surely with the Clock working it should simply be a matter of setting the OnTime function to take the starting time (i.e. when button was clicked) away from the current clock time value?

Hi Folks,

Code is now as follows:
User Form Code:

Please Login or Register  to view this content.

Module 1 Code:

Please Login or Register  to view this content.

Getting an error saying "Object Required" and the bolded line above highlighted in Yellow.

Are we nearly there do you think? When button clicked the form shows figures in each label box before the error comes up?

Ok Guys,

Code below:

Please Login or Register  to view this content.

Module 1 code:

Please Login or Register  to view this content.

When commenting out the SUBTRACTION code, bother the timer label 12 and the start time label14 are working fine. Therefore the problem just seems to be in the code for Label 13 i.e. having the code subtract label14 caption from label12 caption every second.

Any help here would be appreciated.

Thanks xlnitwit

Knew it was something simple.

Its now working, however the elapsed time (label13) only updates every two seconds (this is probably just as a result of my On Time functions clashing.)

Any ideas how to get it to update every second just like the Label12? Should I stagger them by 0.5 sec or what would be best?


Thanks again for all your help!