For example : I have 2 textbox and one Timer control(Its interval=1000)
and I code it in timer Event
Textbox1.text=Time
and Textbox2.text="14:2:20"
When I click the button I want to it display the result
Textbox1-textbox2. But I get the Error
How can I get the correct result.
Thank for your help
In sort: How to calculate between the start time and the end time
(in Minute)

You cna use timevalue() function to convert this into time format and find the difference.

Om Prakash

see the documentation for the DateDiff function, like

diff = DateDiff(myFormat, text1.Text, text2.text)

Marco

In order for this to work, both textboxes must contain datatype Date/Time. If you put

Me.TextBox1 = Now()

You cannot have Me.Textbox2 = "14:2:20" because the quotes " tell me that the value is type TEXT (a string), not Date/Time. Enter it as a real time value. Then use DateDiff("n", Me.TextBox1, Me.TextBox2) for minutes or DateDiff("s", Me.TextBox1, Me.TextBox2) for seconds to get a difference.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

With the DateDiff() function you may want to use the CDate() function on the value of the textbox. I haven't check it out but the text box is likely to always return a string regardless of what you enter.

DateDiff("s", CDate(Me.TextBox1.Text), CDate(Me.TextBox2.Text))

It may even be a good idea to do some validation prior to working with the date as in, IsDate(Me.TextBox1.Text) etc. to ensure that you have a valid date.

Just a thought.

Larry Asher