Convert time values from string to integer

 Time stored into database like hh:mm:ss as a string and I need to convert hours, minutes and seconds to integer in order to complete my own calculation at the below. Does any one can help me please.

Thank you

 

Dim timeDiff As String
            Dim ehours As Integer
            Dim eminutes As Integer
            Dim eseconds As Integer


            ehours = Integer.Parse(Format(lblMonEndClock.Text, "HH"))
            eminutes = Integer.Parse(Format(lblMonEndClock.Text, "mm"))
            eseconds = Integer.Parse(Format(lblMonEndClock.Text, "ss"))

            Dim bhours As Integer
            Dim bminutes As Integer
            Dim bseconds As Integer

            bhours = CInt(Format(lblMonClock.Text, "hh"))
            bminutes = CInt(Format(lblMonClock.Text, "mm"))
            bseconds = CInt(Format(lblMonClock.Text, "ss"))
            Dim sec1, sec2, secOut, minsOut, hoursOut As Integer

            'Convert times to seconds
            sec1 = (ehours * 3600) + (eminutes * 60) + eseconds
            sec2 = (bhours * 3600) + (bminutes * 60) + bseconds

            secOut = sec1 - sec2

            'Calc hours
            hoursOut = Int(secOut / 3600)
            secOut = secOut - (hoursOut * 3600)

            'Calc minutes
            minsOut = Int(secOut / 60)
            secOut = secOut - (minsOut * 60)

            'Convert back to HH:MM:SS
            timeDiff = TimeValue(Format(hoursOut, "00") + ":" + Format(minsOut, "00") + ":" + Format(secOut, "00"))
            lblhour1.Text = timeDiff


Hurolulu
0
hur
12/11/2008 3:44:59 PM
asp.net.visual-basic.net 3721 articles. 0 followers. Follow

10 Replies
885 Views

Similar Articles

[PageSpeed] 24
Get it on Google Play
Get it on Apple App Store

Why don't you use DateTime?  It would make all of the calculations so much easier.

Darrell Norton, MVP
Darrell Norton's Blog


Please mark this post as answered if it helped you!
0
DarrellNorton
12/11/2008 3:57:41 PM

hur:

 Time stored into database like hh:mm:ss as a string and I need to convert hours, minutes and seconds to integer in order to complete my own calculation...

If I understand, you already have values like 09:30:15 stored in the database?

The alternate would be if your database has timedate values in it.

I can work on this with you. Could you also post your front page (aspx page)? It looks like you have six labels.

I'm thinking we could break this down in a few simple questions, show each, and then we could reconstruct your final project.

If I can copy both your pages I can work with them on my machine and then give them back with modifications.

-Larry


Larry Dechent - Sampson Coatings

www.wemakebetterpaint.com has 29 examples (C# & VB) to help beginners with ASP.NET.
0
ldechent
12/11/2008 4:03:09 PM

There is a sql DateDiff function

http://msdn.microsoft.com/en-us/library/ms189794.aspx

This is a link which shows you how to get values--

so you could simply get values like this--

dtsec = Datediff(Sec,Date1,Date2)

dtmin = Datediff(Min,Date1,Date2)

dthour = Datediff(Hour,Date1,Date2)

Is that what you were trying to do?

Jeremy

ohhhh- you are starting with strings--> then do a quick conversion to DateTime- use the Date Diff function afterwards- and you will be done in amuch more clear and concise structure.

0
iamhers
12/11/2008 4:09:39 PM

 <%@ Page Language="VB" AutoEventWireup="false" CodeFile="CoritechTimeSheet.aspx.vb" Inherits="CoritechTimeSheet" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
    <title>Time Sheets</title>
</head>
<script type="text/javascript">

function Clickheretoprint()
{
        var disp_setting="toolbar=yes,location=no,directories=yes,menubar=yes,";
            disp_setting+="scrollbars=yes,width=1050, height=1000, left=50, top=10";
        var content_vlue = document.getElementById("print_content").innerHTML;
        
        var docprint=window.open("","",disp_setting);
            docprint.document.open();
            docprint.document.write('<html><head><title>Work Order</title>');
            docprint.document.write('</head><body onLoad="self.print()"><center>');          
            docprint.document.write(content_vlue);          
            docprint.document.write('</center></body></html>');
            docprint.document.close();
            docprint.focus();
            
}

function SumBoxes()
{

var x= parseFloat(document.Form1.txtMonHour1.value) + parseFloat(document.Form1.txtMonHour2.value) + parseFloat(document.Form1.txtMonHour3.value) + parseFloat(document.Form1.txtMonHour4.value) + parseFloat(document.Form1.txtMonHour5.value) + parseFloat(document.Form1.txtMonHour6.value) + parseFloat(document.Form1.txtMonHour7.value) + parseFloat(document.Form1.txtMonHour8.value) + parseFloat(document.Form1.txtMonHour9.value) + parseFloat(document.Form1.txtMonHour10.value);

 document.Form1.txtTotMonHour1.value =x;
 
var a= parseFloat(document.Form1.txtTueHour1.value) + parseFloat(document.Form1.txtTueHour2.value) + parseFloat(document.Form1.txtTueHour3.value) + parseFloat(document.Form1.txtTueHour4.value) + parseFloat(document.Form1.txtTueHour5.value) + parseFloat(document.Form1.txtTueHour6.value) + parseFloat(document.Form1.txtTueHour7.value) + parseFloat(document.Form1.txtTueHour8.value) + parseFloat(document.Form1.txtTueHour9.value) + parseFloat(document.Form1.txtTueHour10.value);

 document.Form1.txtTotTueHour1.value =a;
 
 var s= parseFloat(document.Form1.txtWenHour1.value) + parseFloat(document.Form1.txtWenHour2.value) + parseFloat(document.Form1.txtWenHour3.value) + parseFloat(document.Form1.txtWenHour4.value) + parseFloat(document.Form1.txtWenHour5.value) + parseFloat(document.Form1.txtWenHour6.value) + parseFloat(document.Form1.txtWenHour7.value) + parseFloat(document.Form1.txtWenHour8.value) + parseFloat(document.Form1.txtWenHour9.value) + parseFloat(document.Form1.txtWenHour10.value);

 document.Form1.txtTotWenHour1.value =s;
 
 var d= parseFloat(document.Form1.txtThurHour1.value) + parseFloat(document.Form1.txtThurHour2.value) + parseFloat(document.Form1.txtThurHour3.value) + parseFloat(document.Form1.txtThurHour4.value) + parseFloat(document.Form1.txtThurHour5.value) + parseFloat(document.Form1.txtThurHour6.value) + parseFloat(document.Form1.txtThurHour7.value) + parseFloat(document.Form1.txtThurHour8.value) + parseFloat(document.Form1.txtThurHour9.value) + parseFloat(document.Form1.txtThurHour10.value);

 document.Form1.txtTotThurHour1.value =d;
 
 var f= parseFloat(document.Form1.txtFriHour1.value) + parseFloat(document.Form1.txtFriHour2.value) + parseFloat(document.Form1.txtFriHour3.value) + parseFloat(document.Form1.txtFriHour4.value) + parseFloat(document.Form1.txtFriHour5.value) + parseFloat(document.Form1.txtFriHour6.value) + parseFloat(document.Form1.txtFriHour7.value) + parseFloat(document.Form1.txtFriHour8.value) + parseFloat(document.Form1.txtFriHour9.value) + parseFloat(document.Form1.txtFriHour10.value);

 document.Form1.txtTotFriHour1.value =f;
 
 var g= parseFloat(document.Form1.txtSatHour1.value) + parseFloat(document.Form1.txtSatHour2.value) + parseFloat(document.Form1.txtSatHour3.value) + parseFloat(document.Form1.txtSatHour4.value) + parseFloat(document.Form1.txtSatHour5.value) + parseFloat(document.Form1.txtSatHour6.value) + parseFloat(document.Form1.txtSatHour7.value) + parseFloat(document.Form1.txtSatHour8.value) + parseFloat(document.Form1.txtSatHour9.value) + parseFloat(document.Form1.txtSatHour10.value);

 document.Form1.txtTotSatHour1.value =g;
 
 var h= parseFloat(document.Form1.txtSunHour1.value) + parseFloat(document.Form1.txtSunHour2.value) + parseFloat(document.Form1.txtSunHour3.value) + parseFloat(document.Form1.txtSunHour4.value) + parseFloat(document.Form1.txtSunHour5.value) + parseFloat(document.Form1.txtSunHour6.value) + parseFloat(document.Form1.txtSunHour7.value) + parseFloat(document.Form1.txtSunHour8.value) + parseFloat(document.Form1.txtSunHour9.value) + parseFloat(document.Form1.txtSunHour10.value);

 document.Form1.txtTotSunHour1.value =h;
 
 var z= parseFloat(document.Form1.txtMonHour1.value) + parseFloat(document.Form1.txtTueHour1.value) + parseFloat(document.Form1.txtWenHour1.value) + parseFloat(document.Form1.txtThurHour1.value) + parseFloat(document.Form1.txtFriHour1.value) + parseFloat(document.Form1.txtSatHour1.value) + parseFloat(document.Form1.txtSunHour1.value);

 document.Form1.TotJob1.value =z;
 
  var c= parseFloat(document.Form1.txtMonHour2.value) + parseFloat(document.Form1.txtTueHour2.value) + parseFloat(document.Form1.txtWenHour2.value) + parseFloat(document.Form1.txtThurHour2.value) + parseFloat(document.Form1.txtFriHour2.value) + parseFloat(document.Form1.txtSatHour2.value) + parseFloat(document.Form1.txtSunHour2.value);

 document.Form1.TotJob2.value =c;
 
  var v= parseFloat(document.Form1.txtMonHour3.value) + parseFloat(document.Form1.txtTueHour3.value) + parseFloat(document.Form1.txtWenHour3.value) + parseFloat(document.Form1.txtThurHour3.value) + parseFloat(document.Form1.txtFriHour3.value) + parseFloat(document.Form1.txtSatHour3.value) + parseFloat(document.Form1.txtSunHour3.value);

 document.Form1.TotJob3.value =v;
 
  var b= parseFloat(document.Form1.txtMonHour4.value) + parseFloat(document.Form1.txtTueHour4.value) + parseFloat(document.Form1.txtWenHour4.value) + parseFloat(document.Form1.txtThurHour4.value) + parseFloat(document.Form1.txtFriHour4.value) + parseFloat(document.Form1.txtSatHour4.value) + parseFloat(document.Form1.txtSunHour4.value);

 document.Form1.TotJob4.value =b;
 
  var n= parseFloat(document.Form1.txtMonHour5.value) + parseFloat(document.Form1.txtTueHour5.value) + parseFloat(document.Form1.txtWenHour5.value) + parseFloat(document.Form1.txtThurHour5.value) + parseFloat(document.Form1.txtFriHour5.value) + parseFloat(document.Form1.txtSatHour5.value) + parseFloat(document.Form1.txtSunHour5.value);

 document.Form1.TotJob5.value =n;
 
  var q= parseFloat(document.Form1.txtMonHour6.value) + parseFloat(document.Form1.txtTueHour6.value) + parseFloat(document.Form1.txtWenHour6.value) + parseFloat(document.Form1.txtThurHour6.value) + parseFloat(document.Form1.txtFriHour6.value) + parseFloat(document.Form1.txtSatHour6.value) + parseFloat(document.Form1.txtSunHour6.value);

 document.Form1.TotJob6.value =q;
 
  var w= parseFloat(document.Form1.txtMonHour7.value) + parseFloat(document.Form1.txtTueHour7.value) + parseFloat(document.Form1.txtWenHour7.value) + parseFloat(document.Form1.txtThurHour7.value) + parseFloat(document.Form1.txtFriHour7.value) + parseFloat(document.Form1.txtSatHour7.value) + parseFloat(document.Form1.txtSunHour7.value);

 document.Form1.TotJob7.value =w;
 
   var e= parseFloat(document.Form1.txtMonHour8.value) + parseFloat(document.Form1.txtTueHour8.value) + parseFloat(document.Form1.txtWenHour8.value) + parseFloat(document.Form1.txtThurHour8.value) + parseFloat(document.Form1.txtFriHour8.value) + parseFloat(document.Form1.txtSatHour8.value) + parseFloat(document.Form1.txtSunHour8.value);

 document.Form1.TotJob8.value =e;
 
  var r= parseFloat(document.Form1.txtMonHour9.value) + parseFloat(document.Form1.txtTueHour9.value) + parseFloat(document.Form1.txtWenHour9.value) + parseFloat(document.Form1.txtThurHour9.value) + parseFloat(document.Form1.txtFriHour9.value) + parseFloat(document.Form1.txtSatHour9.value) + parseFloat(document.Form1.txtSunHour9.value);

 document.Form1.TotJob9.value =r;
 
  var t= parseFloat(document.Form1.txtMonHour10.value) + parseFloat(document.Form1.txtTueHour10.value) + parseFloat(document.Form1.txtWenHour10.value) + parseFloat(document.Form1.txtThurHour10.value) + parseFloat(document.Form1.txtFriHour10.value) + parseFloat(document.Form1.txtSatHour10.value) + parseFloat(document.Form1.txtSunHour10.value);

 document.Form1.TotJob10.value =t;
 document.Form1.txtweek1.value = x + a + s + d + f + g + h;

}
//function Sum()
//{
//var t= parseFloat(document.Form1.txtTotMonHour1.value) + parseFloat(document.Form1.txtTotTueHour1.value) + parseFloat(document.Form1.txtTotWenHour1.value) + parseFloat(document.Form1.txtTotThurHour1.value) + parseFloat(document.Form1.txtTotFriHour1.value) + parseFloat(document.Form1.txtTotSatHour1.value) + parseFloat(document.Form1.txtTotSunHour1.value);

// document.Form1.txtweek1.value =t;

//var b= parseFloat(document.Form1.txtTotMonHour2.value) + parseFloat(document.Form1.txtTotTueHour2.value) + parseFloat(document.Form1.txtTotWenHour2.value) + parseFloat(document.Form1.txtTotThurHour2.value) + parseFloat(document.Form1.txtTotFriHour2.value) + parseFloat(document.Form1.txtTotSatHour2.value) + parseFloat(document.Form1.txtTotSunHour2.value);

// document.Form1.txtweek2.value =b;
//}
//function SumWeek()
//{
//var z= parseFloat(document.Form1.txtweek1.value) + parseFloat(document.Form1.txtweek2.value);
//document.Form1.txtTotalHours.value =z;
//}
//function IMG1_onclick() {

//}

</script>
<body>
<form id="Form1" runat="server">
<table style="width: 100%; margin-top:0; margin-right:0; margin-bottom:0; position: absolute; top: 0px;"><tr><td valign="top" align="center">
    <asp:Image ID="Image1" runat="server" ImageUrl="~/Images/Header2.gif" /></td></tr>
<tr><td valign="top" align="center">
<table style="display:inline; bottom:0px;"><tr>
<td>
    <asp:HyperLink ID="HyperLink1" ImageUrl="~/Images/New Images/WorkOrder.gif" NavigateUrl="~/Index.aspx" runat="server"></asp:HyperLink>
    </td>
    

<td>
    <asp:HyperLink ID="HyperLink3" runat="server" ImageUrl="~/Images/New Images/CreateWorkOrder.gif" NavigateUrl="~/CreateWorkOrder.aspx"></asp:HyperLink>
   </td>


   <td>
        <asp:HyperLink ID="HyperLink2" runat="server" ImageUrl="~/Images/New Images/CoritechEmployeeReport.gif" NavigateUrl="~/Report.aspx"></asp:HyperLink>
 </td>
    <td>
        <asp:HyperLink ID="HyperLink5" runat="server" ImageUrl="~/Images/New Images/HomeWorkOrder.gif" NavigateUrl="~/Homepage.aspx"></asp:HyperLink>
      </td>
     
      
  </tr><tr><td style="background-image: url(Images/New Images/col1.gif)">
</td><td style="background-image: url(Images/New Images/col1.gif)"></td><td style="background-image: url(Images/New Images/col1.gif)"><asp:LinkButton ID="SignOutAction" runat="server" style="font-size: 12px">&raquo;Sign Out</asp:LinkButton>
      </td><td style="background-image: url(Images/New Images/col1.gif)"><asp:Label ID="lblUserName" runat="server" ForeColor="Black" style="font-size: 12px"></asp:Label>
      </td></tr></table>

</td></tr><tr><td style="width: 100%;" align="center">
<table style="width: 100%; display:inline; bottom:0px;"><tr><td><table style="display:inline; bottom:0px;"><tr><td><div class="style3" id="print_content">
<table bordercolor="#86ceff" style="border-right: black 1px solid; border-top: black 1px solid; border-left: black 1px solid; border-bottom: black 1px solid; table-layout: auto; padding-right: 0px; padding-left: 0px; padding-bottom: 0px; margin: 0px; padding-top: 0px; border-collapse: collapse;">
<tr bgcolor="#330099"><td><table style="display:inline"><tr><td><a href="javascript:;" onclick="window.open('popup.aspx?textbox=txtcal','cal','width=250,height=225,left=270,top=180')">
      <img src="images/SmallCalendar.gif" border="0" id="IMG1" language="javascript"></a></td><td style="color: white; text-align:center">
    <asp:TextBox ID="txtcal" runat="server" Width="117px" BorderWidth="0" style="font-weight: normal; color: red"></asp:TextBox><br /><hr />
          <asp:Button ID="Callender" runat="server" Text="Call" /></td></tr></table></td>
          <td style="background-color: #0066cc"><asp:Label ID="lblday1" runat="server" Font-Bold="False" Font-Size="14px" ForeColor="White"></asp:Label></td>
          <td style="background-color: #0066cc"><asp:Label ID="lblday2" runat="server" Font-Bold="False" Font-Size="14px" ForeColor="White"></asp:Label></td>
          <td style="background-color: #0066cc"><asp:Label ID="lblday3" runat="server" Font-Bold="False" Font-Size="14px" ForeColor="White"></asp:Label></td>
          <td style="background-color: #0066cc"><asp:Label ID="lblday4" runat="server" Font-Bold="False" Font-Size="14px" ForeColor="White"></asp:Label></td>
          <td style="background-color: #0066cc"><asp:Label ID="lblday5" runat="server" Font-Bold="False" Font-Size="14px" ForeColor="White"></asp:Label></td>
          <td style="background-color: #0066cc"><asp:Label ID="lblday6" runat="server" Font-Bold="False" Font-Size="14px" ForeColor="White"></asp:Label></td>
          <td style="background-color: #0066cc"><asp:Label ID="lblday7" runat="server" Font-Bold="False" Font-Size="14px" ForeColor="White"></asp:Label></td>
          <td></td>
          </tr>
<tr><td width="150"></td><td>
    <asp:Label ID="lblMon" runat="server"  Width="60px" Font-Size="12px"></asp:Label></td><td>
    <asp:Label ID="lblTue" runat="server"  Width="60px" Font-Size="12px"></asp:Label></td><td>
    <asp:Label ID="lblWen" runat="server"  Width="60px" Font-Size="12px"></asp:Label></td><td>
    <asp:Label ID="lblThur" runat="server"  Width="60px" Font-Size="12px"></asp:Label></td><td>
    <asp:Label ID="lblFri" runat="server"  Width="60px" Font-Size="12px"></asp:Label></td><td>
    <asp:Label ID="lblSat" runat="server"  Width="60px" Font-Size="12px"></asp:Label></td><td>
    <asp:Label ID="lblSun" runat="server"  Width="60px" Font-Size="12px"></asp:Label></td><td style="width: 63px">
    <asp:Label ID="Label1" runat="server" Text="Total"  Width="60px" Font-Size="12px"></asp:Label></td>
</tr>
<tr bgcolor="#d5e7f3"><td>
    <asp:DropDownList ID="DDLJob1" runat="server" Width="93px" Font-Size="12px">
        <asp:ListItem></asp:ListItem>
    </asp:DropDownList></td>
    <td><input type=text id=txtMonHour1 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtTueHour1 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtWenHour1 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtThurHour1 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtFriHour1 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtSatHour1 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtSunHour1 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td bgcolor="#86ceff" style="width: 63px"><INPUT style="WIDTH: 40px; text-align: right; font-size: 12px; height: 13px;" id="TotJob1" type=text  
value="0" runat="server" /></td>
</tr>
<tr bgcolor="white"><td>
    <asp:DropDownList ID="DDLJob2" runat="server" Width="93px" Font-Size="12px">
        <asp:ListItem></asp:ListItem>
    </asp:DropDownList></td>
    <td><input type=text id=txtMonHour2 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtTueHour2 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtWenHour2 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtThurHour2 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtFriHour2 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtSatHour2 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtSunHour2 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td bgcolor="#86ceff" style="width: 63px"><input style="WIDTH: 40px; text-align: right; font-size: 12px; height: 13px;" id="TotJob2" type=text value="0" runat="server" /></td>
</tr>
<tr bgcolor="#d5e7f3"><td>
    <asp:DropDownList ID="DDLJob3" runat="server" Width="93px" Font-Size="12px">
        <asp:ListItem></asp:ListItem>
    </asp:DropDownList></td>
    <td><input type=text id=txtMonHour3 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtTueHour3 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtWenHour3 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtThurHour3 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtFriHour3 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtSatHour3 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtSunHour3 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td bgcolor="#86ceff" style="width: 63px"><INPUT style="WIDTH: 40px; text-align: right; font-size: 12px; height: 13px;" id="TotJob3" type=text
value="0" runat="server" /></td>
</tr>
<tr bgcolor="white"><td>
    <asp:DropDownList ID="DDLJob4" runat="server" Width="93px" Font-Size="12px">
        <asp:ListItem></asp:ListItem>
    </asp:DropDownList></td>
    <td><input type=text id=txtMonHour4 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtTueHour4 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtWenHour4 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtThurHour4 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtFriHour4 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtSatHour4 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtSunHour4 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td bgcolor="#86ceff" style="width: 63px"><input style="WIDTH: 40px; text-align: right; font-size: 12px; height: 13px;" id="TotJob4" type=text value="0" runat="server" /></td>
</tr>

<tr bgcolor="#d5e7f3"><td>
    <asp:DropDownList ID="DDLJob5" runat="server" Width="93px" Font-Size="12px">
        <asp:ListItem></asp:ListItem>
    </asp:DropDownList></td>
    <td><input type=text id=txtMonHour5 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtTueHour5 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtWenHour5 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtThurHour5 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtFriHour5 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtSatHour5 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtSunHour5 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td bgcolor="#86ceff" style="width: 63px"><INPUT style="WIDTH: 40px; text-align: right; font-size: 12px; height: 13px;" id="TotJob5" type=text
value="0" runat="server" /></td>
</tr>
<tr bgcolor="white"><td>
    <asp:DropDownList ID="DDLJob6" runat="server" Width="93px" Font-Size="12px">
        <asp:ListItem></asp:ListItem>
    </asp:DropDownList></td>
    <td><input type=text id=txtMonHour6 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtTueHour6 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtWenHour6 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtThurHour6 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtFriHour6 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtSatHour6 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtSunHour6 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td bgcolor="#86ceff" style="width: 63px"><input style="WIDTH: 40px; text-align: right; font-size: 12px; height: 13px;" id="TotJob6" type=text value="0" runat="server" /></td>
</tr>
<tr bgcolor="#d5e7f3"><td>
    <asp:DropDownList ID="DDLJob7" runat="server" Width="93px" Font-Size="12px">
        <asp:ListItem></asp:ListItem>
    </asp:DropDownList></td>
    <td><input type=text id=txtMonHour7 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtTueHour7 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtWenHour7 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtThurHour7 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtFriHour7 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtSatHour7 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtSunHour7 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td bgcolor="#86ceff" style="width: 63px"><INPUT style="WIDTH: 40px; text-align: right; font-size: 12px; height: 13px;" id="TotJob7" type=text  
value="0" runat="server" /></td>
</tr>
<tr bgcolor="white"><td style="height: 23px">
    <asp:DropDownList ID="DDLJob8" runat="server" Width="93px" Font-Size="12px">
        <asp:ListItem></asp:ListItem>
    </asp:DropDownList></td>
    <td style="height: 23px"><input type=text id=txtMonHour8 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td style="height: 23px"><input type=text id=txtTueHour8 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td style="height: 23px"><input type=text id=txtWenHour8 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td style="height: 23px"><input type=text id=txtThurHour8 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td style="height: 23px"><input type=text id=txtFriHour8 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td style="height: 23px"><input type=text id=txtSatHour8 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td style="height: 23px"><input type=text id=txtSunHour8 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td bgcolor="#86ceff" style="width: 63px; height: 23px;"><input style="WIDTH: 40px; text-align: right; font-size: 12px; height: 13px;" id="TotJob8" type=text value="0" runat="server" /></td>
</tr>
<tr bgcolor="#d5e7f3"><td>
    <asp:DropDownList ID="DDLJob9" runat="server" Width="93px" Font-Size="12px">
        <asp:ListItem></asp:ListItem>
    </asp:DropDownList></td>
    <td><input type=text id=txtMonHour9 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtTueHour9 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right;"></td>
    <td><input type=text id=txtWenHour9 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtThurHour9 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtFriHour9 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtSatHour9 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtSunHour9 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td bgcolor="#86ceff" style="width: 63px"><INPUT style="WIDTH: 40px; text-align: right; font-size: 12px; height: 13px;" id="TotJob9" type=text
value="0" runat="server" /></td>
</tr>
<tr bgcolor="white"><td>
    <asp:DropDownList ID="DDLJob10" runat="server" Width="93px" Font-Size="12px">
        <asp:ListItem></asp:ListItem>
    </asp:DropDownList></td>
    <td><input type=text id=txtMonHour10 runat="server" value=0  onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtTueHour10 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtWenHour10 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtThurHour10 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtFriHour10 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtSatHour10 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtSunHour10 runat="server" value=0 onactivate="SumBoxes();" style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td bgcolor="#86ceff" style="width: 63px"><input style="WIDTH: 40px; text-align: right; font-size: 12px; height: 13px;" id="TotJob10" type=text value="0" runat="server" /></td>
</tr>
<tr bgcolor="#86ceff"><td style="font-weight: bold; font-size: 14px"></td>
    <td><input type=text id=txtTotMonHour1 runat="server" value=0  style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtTotTueHour1 runat="server" value=0  style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtTotWenHour1 runat="server" value=0  style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtTotThurHour1 runat="server" value=0  style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtTotFriHour1 runat="server" value=0  style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtTotSatHour1 runat="server" value=0  style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td><input type=text id=txtTotSunHour1 runat="server" value=0  style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td>
    <td bgcolor="#86ceff" style="width: 63px"></td>
</tr>
<tr><td align="left"><table style="display:inline"><tr><td style="font-weight: bold; font-size: 14px">Total Hours:</td><td><input type=text id=txtweek1 runat="server" value=0 style="width: 40px; text-align: right; font-size: 12px; height: 13px;"></td></tr></table></td><td></td><td></td><td></td>
<td></td><td></td><td></td><td>
    </td></tr>
    <tr><td style="color: white; background-color: #cc0000; text-align: center">Start Time</td>
    <td align="center"><span><asp:TextBox ID="lblMonClock" runat="server" Font-Size="10px" Width="70px" ForeColor="#C00000" Enabled="False" style="text-align: center"></asp:TextBox></span><br /><a href="javascript:;" onclick="window.open('popupClock.aspx?textbox=lblMonClock','cal','width=250,height=225,left=270,top=180')">
      <img src="Images/clock.jpg" border="0" id="IMG2" language="javascript"></a></td>
    <td align="center"><span><asp:TextBox ID="lblTueClock" runat="server" Font-Size="10px" Width="70px" ForeColor="#C00000" Enabled="False" style="text-align: center"></asp:TextBox></span><br /><a href="javascript:;" onclick="window.open('popupClock.aspx?textbox=lblTueClock','cal','width=250,height=225,left=270,top=180')">
      <img src="Images/clock.jpg" border="0" id="IMG3" language="javascript"></a></td>
    <td align="center"><span><asp:TextBox ID="lblWenClock" runat="server" Font-Size="10px" Width="70px" ForeColor="#C00000" Enabled="False" style="text-align: center"></asp:TextBox></span><br /><a href="javascript:;" onclick="window.open('popupClock.aspx?textbox=lblWenClock','cal','width=250,height=225,left=270,top=180')">
      <img src="Images/clock.jpg" border="0" id="IMG4" language="javascript"></a></td>
    <td align="center"><span><asp:TextBox ID="lblThurClock" runat="server" Font-Size="10px" Width="70px" ForeColor="#C00000" Enabled="False" style="text-align: center"></asp:TextBox></span><br /><a href="javascript:;" onclick="window.open('popupClock.aspx?textbox=lblThurClock','cal','width=250,height=225,left=270,top=180')">
      <img src="Images/clock.jpg" border="0" id="IMG5" language="javascript"></a></td>
    <td align="center"><span><asp:TextBox ID="lblFriClock" runat="server" Font-Size="10px" Width="70px" ForeColor="#C00000" Enabled="False" style="text-align: center"></asp:TextBox></span><br /><a href="javascript:;" onclick="window.open('popupClock.aspx?textbox=lblFriClock','cal','width=250,height=225,left=270,top=180')">
      <img src="Images/clock.jpg" border="0" id="IMG6" language="javascript"></a></td>
    <td align="center"><span><asp:TextBox ID="lblSatClock" runat="server" Font-Size="10px" Width="70px" ForeColor="#C00000" Enabled="False" style="text-align: center"></asp:TextBox></span><br /><a href="javascript:;" onclick="window.open('popupClock.aspx?textbox=lblSatClock','cal','width=250,height=225,left=270,top=180')">
      <img src="Images/clock.jpg" border="0" id="IMG7" language="javascript"></a></td>
    <td align="center"><span><asp:TextBox ID="lblSunClock" runat="server" Font-Size="10px" Width="70px" ForeColor="#C00000" Enabled="False" style="text-align: center"></asp:TextBox></span><br /><a href="javascript:;" onclick="window.open('popupClock.aspx?textbox=lblSunClock','cal','width=250,height=225,left=270,top=180')">
      <img src="Images/clock.jpg" border="0" id="IMG8" language="javascript"></a></td><td></td></tr>
      <tr><td style="color: white; background-color: #cc0000; text-align: center">End Time</td>
    <td align="center"><span><asp:TextBox ID="lblMonEndClock" runat="server" Font-Size="10px" Width="70px" ForeColor="#C00000" Enabled="False" style="text-align: center"></asp:TextBox></span><br /><a href="javascript:;" onclick="window.open('popupClock.aspx?textbox=lblMonEndClock','cal','width=250,height=225,left=270,top=180')">
      <img src="Images/clock.jpg" border="0" id="IMG9" language="javascript"></a></td>
    <td align="center"><span><asp:TextBox ID="lblTueEndClock" runat="server" Font-Size="10px" Width="70px" ForeColor="#C00000" Enabled="False" style="text-align: center"></asp:TextBox></span><br /><a href="javascript:;" onclick="window.open('popupClock.aspx?textbox=lblTueEndClock','cal','width=250,height=225,left=270,top=180')">
      <img src="Images/clock.jpg" border="0" id="IMG10" language="javascript"></a></td>
    <td align="center"><span><asp:TextBox ID="lblWenEndClock" runat="server" Font-Size="10px" Width="70px" ForeColor="#C00000" Enabled="False" style="text-align: center"></asp:TextBox></span><br /><a href="javascript:;" onclick="window.open('popupClock.aspx?textbox=lblWenEndClock','cal','width=250,height=225,left=270,top=180')">
      <img src="Images/clock.jpg" border="0" id="IMG11" language="javascript"></a></td>
    <td align="center"><span><asp:TextBox ID="lblThurEndClock" runat="server" Font-Size="10px" Width="70px" ForeColor="#C00000" Enabled="False" style="text-align: center"></asp:TextBox></span><br /><a href="javascript:;" onclick="window.open('popupClock.aspx?textbox=lblThurEndClock','cal','width=250,height=225,left=270,top=180')">
      <img src="Images/clock.jpg" border="0" id="IMG12" language="javascript"></a></td>
    <td align="center"><span><asp:TextBox ID="lblFriEndClock" runat="server" Font-Size="10px" Width="70px" ForeColor="#C00000" Enabled="False" style="text-align: center"></asp:TextBox></span><br /><a href="javascript:;" onclick="window.open('popupClock.aspx?textbox=lblFriEndClock','cal','width=250,height=225,left=270,top=180')">
      <img src="Images/clock.jpg" border="0" id="IMG13" language="javascript"></a></td>
    <td align="center"><span><asp:TextBox ID="lblSatEndClock" runat="server" Font-Size="10px" Width="70px" ForeColor="#C00000" Enabled="False" style="text-align: center"></asp:TextBox></span><br /><a href="javascript:;" onclick="window.open('popupClock.aspx?textbox=lblSatEndClock','cal','width=250,height=225,left=270,top=180')">
      <img src="Images/clock.jpg" border="0" id="IMG14" language="javascript"></a></td>
    <td align="center"><span><asp:TextBox ID="lblSunEndClock" runat="server" Font-Size="10px" Width="70px" ForeColor="#C00000" Enabled="False" style="text-align: center"></asp:TextBox></span><br /><a href="javascript:;" onclick="window.open('popupClock.aspx?textbox=lblSunEndClock','cal','width=250,height=225,left=270,top=180')">
      <img src="Images/clock.jpg" border="0" id="IMG15" language="javascript"></a></td><td></td></tr>
    <tr>
    <td style="color: white; background-color: #cc0000; text-align: center">Hours</td>
    <td><asp:Label ID="lblhour1" runat="server"></asp:Label></td>
    <td><asp:Label ID="lblhour2" runat="server"></asp:Label></td>
    <td><asp:Label ID="lblhour3" runat="server"></asp:Label></td>
    <td><asp:Label ID="lblhour4" runat="server"></asp:Label></td>
    <td><asp:Label ID="lblhour5" runat="server"></asp:Label></td>
    <td><asp:Label ID="lblhour6" runat="server"></asp:Label></td>
    <td><asp:Label ID="lblhour7" runat="server"></asp:Label></td>
    </tr>
      <tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>
    <asp:Button ID="SaveTimesheet" runat="server" Text="Save" Font-Bold="True" Width="51px" /></td></tr>
    
    </table>
    </div></td></tr>
    <tr><td>
    
    </td></tr><tr><td></td></tr><tr><td></td></tr><tr><td></td></tr></table></td></tr>
<tr><td align="center" valign="top">
    </td></tr></table>
</td></tr><tr><td>
    </td></tr><tr><td align=right><a href="javascript:Clickheretoprint()" style="color: Blue">Print Results</a></td></tr><tr><td>
        <asp:Label ID="lblResults" runat="server"></asp:Label></td></tr><tr><td align="center">
        </td></tr></table>


   <br/><br/>
    

    
</form>

</body>
</html>
Thank you sir


Hurolulu
0
hur
12/11/2008 4:20:44 PM

 Datetime format holds mm/dd/yyyy hh:mm:ss (AM and PM). I need to store only hh:mm:ss. format. hh is between 1 to 24.


Hurolulu
0
hur
12/11/2008 4:25:26 PM

OK, is this how it works...

  • If I work 5 hours on monday the answer is 5:00:00
  • If I work 4 and a half hours on Tuesday the answer is 4:30:00

?

If so,

Is it correct that if I only worked for those two days, the answer for the week is 9:30:00 and you want to be able to calculate this?

-Larry

 


Larry Dechent - Sampson Coatings

www.wemakebetterpaint.com has 29 examples (C# & VB) to help beginners with ASP.NET.
0
ldechent
12/11/2008 4:38:17 PM

 

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Hur.aspx.vb" Inherits="Hur" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    
        <asp:TextBox ID="InputTextBox" runat="server"></asp:TextBox>
        <br /><br />
        <asp:Button ID="Button1" runat="server" Text="Send" />
        <br /><br />
        Hours: <asp:Label ID="HoursLabel" runat="server"></asp:Label><br />
        Minutes: <asp:Label ID="MinutesLabel" runat="server"></asp:Label><br />
        Seconds: <asp:Label ID="SecondsLabel" runat="server"></asp:Label><br />

        <br /><br />
        
        Total seconds: <asp:Label ID="TotalSecondsLabel" runat="server"></asp:Label>

    </div>
    </form>
</body>
</html>

 ***********************************

Partial Class Hur
    Inherits System.Web.UI.Page



    Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click

        Dim fullstring As String = InputTextBox.Text

        Dim splittee() As String = fullstring.Split(":")

        HoursLabel.Text = splittee(0)
        MinutesLabel.Text = splittee(1)
        SecondsLabel.Text = splittee(2)

        Dim Hours As Integer = Convert.ToInt32(HoursLabel.Text)
        Dim Minutes As Integer = Convert.ToInt32(MinutesLabel.Text)
        Dim Seconds As Integer = Convert.ToInt32(SecondsLabel.Text)

        Dim totalseconds As Integer = (3600 * Hours) + (60 * Minutes) + Seconds

        TotalSecondsLabel.Text = totalseconds.ToString() + " seconds"

    End Sub
End Class
 
Larry Dechent - Sampson Coatings

www.wemakebetterpaint.com has 29 examples (C# & VB) to help beginners with ASP.NET.
0
ldechent
12/11/2008 5:21:53 PM

Does the above example answer the question you needed to have answered?  Are there other questions?

Holiday Regards,

-Larry


Larry Dechent - Sampson Coatings

www.wemakebetterpaint.com has 29 examples (C# & VB) to help beginners with ASP.NET.
0
ldechent
12/11/2008 5:23:49 PM

hur,

There are formatting options that will grab out what you want- so you can store what ever you like. that is the beauty of the DateTime format- It holds all of the options so you can grab what you need.

 

Simply- Best practices say if it is date or time store it as that and write code to manage on client level-- if this is not what you want to do - then i would still suggest setting it as a date time- and then grab out value you want- in your case hours, minutes, and seconds- this will save you a lot-- i repeat -- a lot of time in the long run.

It will do one more thing for you- make your code consistant and reusable.- which again will save you time... do you need an example?

0
iamhers
12/11/2008 5:33:49 PM

 Thank you so much Larry. The script you gave me help so much.

Best Regards

Happy great Holiday


Hurolulu
0
hur
12/11/2008 6:44:12 PM
Reply:

Similar Artilces:

Converting Visual Basic 6 to Visual Basic .NET
Hi, I found this program that would get the mac address of a computer given its IP. I converted it into vb.net and it gave 2 errors. It said that I couldn't use "any" in declarations, so I found out what variable it was tryign to pass and changed the any to that data type. Now, the program will start in vb.net... but when I click the button, it returns the wrong mac address, while the one in vb6 returned the correct one.All you have to do is add 2 textboxes to the form and 1 button, dont change their names.::::::::::VB6 CODE::::::::::Option ExplicitPrivate Const NO_ERROR = 0Private Declare F...

Visual Basic.NET or Visual Studio.NET?
OK, this has probably been asked before... I'm a student looking to cut my costs, and I can do this by just purchasing Visual Basic.NET as opposed to the fully-fledged Visual Studio.NET application. Of course, I'll only be able to program in VB, but that's fine with me. I wanted to know if all of the ASP.NET specific options are available, such as using a WYSIWYG editor? I'd also like to know if VB.NET has IntelliSense, or that's a specific option only available to Visual Studio.NET users. Thanks in advance. I'd have to believe that VB.Net has intellisense. What is the price d...

Visual Studio .Net? Visual Basic .Net?
Okay, I admit it -- I know nothing about .Net. I'm a Visual Basic and ASP developer. DotNetNuke is my first tentative step into the whole ".Net Thing", and I'm looking for some advice... What do I really need to be able to make some modifications, or new modules for DotNetNuke? Do I need the full, THOUSAND DOLLAR Visual Studio .Net 2003 package, or can I get away with the HUNDRED DOLLAR Visual Basic .Net Standard package?Chameleon Systems, Inc. You can use webmatrix, available here for free. One of the drawbacks of webmatrix however is that it does not support code-be...

Visual Basic.NET or Visual Studio.NET? #2
I am currently using the Web Matrix to develop ASP.NET applications, but I am keep to upgrade to VS.NET. However, I can't justify spending $1,000 at the moment. I then found the MUCH cheaper "Visual Basic .NET 2003 Standard Edition" which is only $100. I have very little C# knowledge, and use Basic almost all the time. Would this be a good tool to use for web development? Does it support all the code behind stuff that VS users love so much? Thanks!! I use "VB.NET Standard Edition" and I'm happy with it. It has exactly the same features as Visual Studio.NET. Th...

What are the diff. visual basic 6 and vb.net ? How to convert the VB6 project to vb.net proj ?
What are the diff. visual basic 6 and vb.net ? How to convert the VB6 project to vb.net proj ? with code and interface too. There are entire forums dedicated to the differences between the two, and to convert your projects you should try the upgrade wizard in Visual Studio....

Visual Basic .NET 2003 vs Visual Studio .NET 2003
Hi, If im going to be coding my ASP.NET in just VB.NET then would I be able to go for the cheaper option of buying Visual Basic .NET 2003 ?? - Carl S Yes.Starting with ASP.NET 2.0? Look at:Programming Microsoft Web Forms My Blog Are there any limitations if I was doing my ASP.NET with VB.NET in Visual Basic .NET 2003 than if I was using the full Visual Studio .NET 2003 ?? Or are the only advantages of Visual Studio .NET 2003 in that it supports more programming languages ?? - Carl S You should check the MS Web site, but I believe that, given an edition (Standard, Professional...

Why Visual Studio 2005 ask me to convert a solution already got converted Somebody did the conversion of a solution from .net 1.1 to .net 2.0 by using the automatic conversion wizard of Visual Stu
Why Visual Studio 2005 ask me to convert a solution already got converted Somebody did the conversion of a solution from .net 1.1 to .net 2.0 by using the automatic conversion wizard of Visual Studio 2005. Then, he changed to another company. Now, I take over his job. Unfortunately, when I attempted to open that solution, Visual Studio 2005 prompted me the conversion wizard again to forced me to perform a conversion on the solution. Does someone know why?--Harish Patel www.MicrosoftSQLandASP.netpatelharish@gmail.com Hi, How many projects are in the solution, does it have UNLOADE...

ADO.NET Programming in Visual Basic .NET
Has anyone read "ADO.NET Programming in Visual Basic .NET, Second Edition" by Steve Holzner (Author), Bob Howell (Author)? I am trying to working on a project and there are a few things that I need to tie up quickly in my web forms. Is this book a good one? karls------------------------------------'Old and wrinkled is not what I expected to become when I grew up!'...

Converting windows application using web service from Visual C#.net 2003 to Visual Studio.net 2005
Hello, everyone! I have a solution which contains a windows project,a web service project and several other library projects. These projects were coded under visual c#.net 2003. Now I need to converted them to use Visual Studo.net 2005. Does any one know any article providing step-by-step guide  to converting WINDOWS APPLICATION with web service? I can find one under MSDN for converting web project.  But I guess I am a little confused if mine should follow this article since I am using web service in my windows application? Thanks a lot in advance.  ...

converting to vb.net from c#.net authorize.net
authorize.net offered me some sample code when I signed up with them the only problem is the sample code is in c#.net but my page that they type all of their credit card into is vb.net <code><%@ Import Namespace="System.Net" %> <%@ Import Namespace="System.IO" %> <script language="C#" runat="server"> void Page_Load(Object Src, EventArgs E) { myPage.Text = readHtmlPage("https://certification.authorize.net/gateway/transact.dll"); } private String readHtmlPage(string url) { ...

C# Visual Basic.NET JScript.NET what should I choose ?
I'm just a beginner with programing ASP.NET web sistes. Unfortunatelly I don't know any of the languages supported by ASP. (By the time I programmed in DELPHI and SQL) So I should start to learn one of the languages. Could somebody help me to choose the language I should use ? Which and why ? Thanks in advance, Gonzi Use C# or VB.NET, which ever you are comfortable with. Go here to see sample of both in use http://samples.gotdotnet.com/quickstart/aspplus Ultimately, once you get more advanced, you'll really want to become comfortable with both languages. I ...

Convert VBA Code to Visual Basic .NET When Migrating to Visual Studio 2005 Tools for Office
followup to grc.techtalk Convert VBA Code to Visual Basic .NET When Migrating to Visual Studio 2005 Tools for Office http://msdn.microsoft.com/office/default.aspx?pull=/library/en-us/odc_vsto2005_ta/html/OfficeVSTOLanguageMigrationFromVBA.asp ----------------------------------------------------------- Quote ----------------------------------------------------------- Dale Oberg ArtinSoft.com March 2005 Applies to: �����Microsoft�Visual�Studio�2005 �����Microsoft�Visual�Studio�2005�Tools�for�the�Microsoft�Office�System �����Microsoft�Visual�Basic�.NET �����Microsoft�Visual�...

Can I go from VS .NET 2003 to Visual Basic .NET 2003?
Hi, I just developed a commercial application using the trial version of Visual Studio .NET 2003.  My trial is about to expire.  I was hoping .NET 2.0 would be released by now, but that is obviously months away so I'm wondering if I could save a few hundred bucks by buying Visual Basic .NET 2003(around $110 i think) instead of having to buy Visual Studio .NET 2003, which I believe is up around $600 or so.   All my code is Visual Basic, so that's why I'm thinking that's all I need.  And it's mostly web development that I do if that matters.  T...

Is there any function to convert string to integer in VB.net?
Is there any function to convert string to integer in VB.net? thank you very much.As Heinlein said "specialization is for insects" explore beyond the universe. Hi There, You can do this Dim Val as String = "50" Dim i As Integer = Convert.ToInt32(Val)DC517Don't forget to click "Mark as Answer" on the post that helped you. This credits that member, earns you a point and marks your thread as Resolved. thank you very much dennisAs Heinlein said "specialization is for insects" explore beyond the universe. Hi There, No problem, always welcome...

Web resources about - Convert time values from string to integer - asp.net.visual-basic.net

File:Convert to SVG and move to Commons.svg - Wikipedia, the free encyclopedia
As a courtesy (but not a requirement), please e-mail me or leave a note on my talk page if you use this image outside of Wikipedia. Thanks! As ...

Facebook Co-Founder Dustin Moskovitz Sells 450K Shares, Converts 7M More
The great Facebook stock sale frenzy continues on with a report that Co-Founder Dustin Moskovitz unloaded 450,000 shares in the social network ...

Facebook Announces “App2User” Liquidity Program for Merchants to Convert Rewards Points into Credits
... for Credits, just announced a new Credits program called “App2User,” designed to enable merchants and loyalty program operators to convert their ...

How to Convert Leads Into Buying Customers - The 9 Step Sales Process EVERYONE Should Use
... School of Business in Toronto on the topics of Sales and Entrepreneurship. I shared with them the sales process that I find How to Convert Leads ...

Bitcoin : Should I convert my savings to Bitcoin?
Answer (1 of 7): You should think of this question as "Should I invest all my savings in Bitcoin?", and not "Should I have my savings denominated ...

Convertizo 2 - Convert Units and Currency in Style on the App Store on iTunes
Get Convertizo 2 - Convert Units and Currency in Style on the App Store. See screenshots and ratings, and read customer reviews.

Radical plan to convert Domain Stadium into a wave park
The man behind a radical plan to convert Domain Stadium into an artificial wave park, says it will become &nbsp;a sporting spectacle for wave-starved ...

WWE diva converts to Christianity, confesses to a life of sin
Stunning wrestling diva Taryn Terrell has shared a dramatic knock-down testimony of conversion from life in the ring to life with Christ.

Microsoft converts more customers into testers with Office Insider preview program
Microsoft today launched a new preview program for consumers who subscribe to Office 365 that will give them a sneak peak at new features slated ...

'Water Bug' Robot Digests Pollution, Converts it to Electricity
The Row-Bot was capable of generating more energy than it needed.

Resources last updated: 11/27/2015 4:16:17 AM