("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 -
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
© COPYRIGHT 2024 ASPSnippets.com ALL RIGHTS RESERVED.