Time Conversion

Jeremy.Carter · May 16th, 2011, 05:45 PM

I am Having a problem with a program I am tring to get the difference between two times and display that difference into a text box

This is the code I have

Dim Duration As DateTime
Duration = Date.FromOADate(Time_OutTextBox.Text - Time_InTextBox.Text)
Time_InTextBox.Text = Convert.ToDateTime(Time_InTextBox)
Time_OutTextBox.Text = Convert.ToDateTime(Time_OutTextBox)
Total_HoursTextBox.Text = Convert.ToDateTime(Duration)
Me.Total_HoursTextBox.Text = Convert.ToDateTime(Duration)

I keep getting this when I try to run it
Coversion from string "0:00" to type 'Double' is not valid

Can anyone Help

disel2010 · May 17th, 2011, 02:56 AM

HI,

in the line

Code:

Duration = Date.FromOADate(Time_OutTextBox.Text - Time_InTextBox.Text)

you are substracting two strings (not DateTime objects yet!) and then call the function Date.FromOADate to convert a double to a DateTime..

If you want to do DateTime arithmetics you should first convert the strings to a DateTime:

Code:

Duration = Convert.ToDateTime(Time_OutTextBox) - Convert.ToDateTime(Time_InTextBox)

Hope this helps...

By the way, this looks like vb.net and not vb6? Then, if my answer isn't exactly what you were looking after, you could be better off posting your question in one of the .NET forums to reach those experts..