InstantForum.NET v4.1.1A1VBCode Forumshttp://www.a1vbcode.com/vbforums/forums@a1vbcode.comThu, 09 Feb 2012 04:08:10 GMT20http://www.a1vbcode.com/vbforums/Topic23940-9-1.aspxHi All - Happy New Year.</P><P>does anyone know how to add the following values together?</P><P>00:00:10</P><P>00:10:40</P><P>02:40:20</P><P>etc..</P><P>basically they are timespan values written to the database indiviually and now that i recall them - i am having difficulty adding them together to get a total Value.</P><P>i was using this:</P><FONT size=2><P></FONT><FONT color=#0000ff size=2>Dim</FONT><FONT size=2> qty, price </FONT><FONT color=#0000ff size=2>As</FONT><FONT size=2> </FONT><FONT color=#0000ff size=2>Decimal</FONT></P><P><FONT size=2>qty = Val(</FONT><FONT color=#0000ff size=2>Me</FONT><FONT size=2>.TextBox1.Text)</P><P>price = Val(</FONT><FONT color=#0000ff size=2>Me</FONT><FONT size=2>.TextBox2.Text)</P><P>TextBox3.Text = qty * price</P><P>the problem occurs with the ":" - but i cannot figure a way around it.</P></FONT>Sun, 13 Jan 2008 17:27:33 GMTPoy