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 ...