("Working_Hour") = (Convert.ToDateTime(dr(4)) - Convert.ToDateTime(dr(3))) + (Convert.ToDateTime(dr(6)) - Convert.ToDateTime(dr(5))) + (Convert.ToDateTime(dr(8)) - Convert.ToDateTime(dr(7))) '"if entries are 6 then add this line in working hour
shows working hour in -
give me values of dr(4),dr(3),dr(5),dr(6),dr(7),dr(8) so i give u solution
dr(4),dr(3),dr(5),dr(6),dr(7),dr(8) data come from databse like 04:10:10 PM, 03:30:10 , 01:10:10 PM, 02:10:10 PM, 11:00:00 AM, 10:00:00 AM
check one by one substration is any substration giving you -ve value
actully in when value save in database then first enter am values and after that pm values when these values ie pm-am then it gives answer in -ve
try like this
TimeSpan dt = DateTime.Parse("3/29/2012 05:14:35 PM").Subtract(DateTime.Parse("3/29/2012 09:14:35 AM")); int hh = dt.Hours;
© COPYRIGHT 2025 ASPSnippets.com ALL RIGHTS RESERVED.