Posted on: 10/28/2013 12:12:43 PM | Views : 709

Hi can you help me formulate the following on gridview. Im tryin go get the compliance of a transaction within 24 hours

<asp:BoundField DataField="Time_Rcvd" HeaderText="Time_Rcvd" SortExpression="Time_Rcvd" /> <asp:BoundField DataField="Time_Finished" HeaderText="Time_Finished" SortExpression="Time_Finished" />
<asp:TemplateField HeaderText="Ellapsed" SortExpression="Ellapsed"> <EditItemTemplate><asp:TextBox ID="Ellapsed" runat="server" Text='<%# **********blank*************)) %>'> ReadOnly= "true" Visible="true"></asp:TextBox> </EditItemTemplate> </asp:TemplateField>
Note that formula here is: IF((Time_Finished - Time_Rcvd)<=0 ,(0.75 - Time_Rcvd) * 24 + (Time_Finished - 0.375) * 24 , (Time_Finished - Time_Rcvd) ...

Go to the complete details ...