0

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.

5
Contributors
4
Replies
5
Views
10 Years
Discussion Span
Last Post by venkatramasamy
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.

0

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

0

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

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.