preludeofme
New Member
- Joined
- Dec 4, 2008
- Messages
- 34
Morning!
So i've been having some issues with a program i've setup, i have a user interface (userforms) that pulls and pushes information through various screens/programs. I am trying to capture the time it takes for someone to complete the task from start to finish but i'm getting some weird numbers.
so when they first open the first userform i have it doing this:
then as it goes to each subsequent userform (i have it opening different userforms based on what they are doing) i have it passing the information to the next one
then at the end i have the following code to pull the processing time
now it seems to be working for the most part, but i'm getting some weird numbers. sometimes it will show that someone was using it for 100+minutes when i know it was only like 2 minutes.
Anyone know of any issues or know of a different way to calculate the processing time between multiple userforms?
So i've been having some issues with a program i've setup, i have a user interface (userforms) that pulls and pushes information through various screens/programs. I am trying to capture the time it takes for someone to complete the task from start to finish but i'm getting some weird numbers.
so when they first open the first userform i have it doing this:
Code:
Private Sub UserForm_Initialize()
Open_Time.Caption = now()
End Sub
Code:
Private Sub CommandButton1_Click()
Userform2.Open_Time.Caption = userform1.Open_Time.Caption
End Sub
then at the end i have the following code to pull the processing time
Code:
EndTime = Now()
Processing_Time= EndTime - Userform2.Start_Time.Caption
now it seems to be working for the most part, but i'm getting some weird numbers. sometimes it will show that someone was using it for 100+minutes when i know it was only like 2 minutes.
Anyone know of any issues or know of a different way to calculate the processing time between multiple userforms?