954,535 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

I'm an apprentice.Please

I'm an aprentice to VB,but have a little knowledge and interested in doing experiments.
What i want to know is,how to get the time difference?
text1.text includes the 1st updated time and text2.text includes the 2nd updated time.text3.text must be the difference between two times.
please teach me to do this.

Randika
Newbie Poster
7 posts since Nov 2006
Reputation Points: 10
Solved Threads: 0
 

Perhaps you can use Hour(Time) , Minute(Time) , and Second(Time) to get the hour, minute and second respectively for each of the two time points.

scudzilla
Posting Whiz in Training
277 posts since Mar 2007
Reputation Points: 27
Solved Threads: 17
 

Use the datediff function.

TimeDiff = DateDiff("n", Time1, Time2)

will give the time difference in minutes. For difference in seconds, use "s" instead of "n". Look up the datediff function in the Help files to see the syntax and various parameter options

aparnesh
Junior Poster
194 posts since Jul 2005
Reputation Points: 20
Solved Threads: 10
 

in vb you can get the current time by using now()

jbennet
Moderator
Moderator
18,523 posts since Apr 2005
Reputation Points: 1,826
Solved Threads: 601
 

HI

you need to set the Time Difff in text3 control right, then use the following code under any event

text3.text=DateDiff("n",cdate(text1.text),cdate(text2.text)

it is suggeted to check for the valid time entry by using the isdate function
Ex:
if isdate(text1.text)=false then
msgbox "Not Valid Time"

end if

hope this will help you,

regards
Venkatramasamy Sn

venkatramasamy
Junior Poster in Training
71 posts since Aug 2007
Reputation Points: 12
Solved Threads: 12
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You