datediff (date(g.solvedate),date(g.date)) 
								-truncate((case when date(g.solvedate)=date(g.date) 
										then (case when (weekday(g.date) = 5 or weekday(g.date) = 6) 
													then 1 
													else 0 
											  end)
										else case when (week(date(g.solvedate),1) = week(date(g.date),1) and date(g.solvedate)-date(g.date) < 7) 
												   then (case when (weekday(g.solvedate) = 5) 
															  then 1 
															  when (weekday(g.solvedate) = 6) 
															  then 2 
															  else 0  
														 end) 
												   else  case when (6-weekday(date(g.date)) = 0) 
															  then 1 
															  else 2 
														 end 
														+case when (6-weekday(date(g.solvedate))=1) 
															  then 1 
															  when (6-weekday(date(g.solvedate))=0) 
															  then 2 
															  else 0 
														 end 
													    +(datediff (date(g.solvedate),date(g.date))-(6-weekday(date(g.date)))-1-weekday(date(g.solvedate)))/7*2 
											  end 
								   end),0) AS workday
###################################################################################################################
round((case   when g1.workday = 0 and date(g.solvedate)=date(g.date)
	                    then (case when time(g.date) < '06:00:00' 
								          then time_to_sec (timediff (time(g.solvedate),'06:00:00')) 
								          else time_to_sec (timediff(g.solvedate,g.date))	
							         end)
	                    when g1.workday = 1 
                       then (case when time(g.date) < '06:00:00' 
								  then time_to_sec (timediff (time(g.solvedate),'06:00:00')) 
								  else time_to_sec (timediff(g.solvedate,g.date))	
							 end)
					   when  g1.workday = 2
                       then (case when time(g.date) < '06:00:00' 
								  then time_to_sec (timediff ('18:00:00','06:00:00')) 
								  else time_to_sec (timediff('18:00:00',time(g.date)))	
							 end) + time_to_sec (timediff(time(g.solvedate),'06:00:00'))
					   else (case when time(g.date) < '06:00:00' 
								  then time_to_sec (timediff ('18:00:00','06:00:00')) 
								  else time_to_sec (timediff('18:00:00',time(g.date)))	
						     end) + (g1.workday-2)*8 + time_to_sec (timediff(time(g.solvedate),'06:00:00'))
                 end) / 3600,1)
#######################################################################################################################