select sum(shijian) from (
select datediff(second,'2020-04-16 10:10:01','2020-04-16 08:40:01') biaozhi,datediff(second,'2020-04-16 08:40:01',getdate()) times,600 shijian
union all
select datediff(second,'2020-04-16 12:15:01','2020-04-16 08:40:01') biaozhi,datediff(second,'2020-04-16 12:15:01',getdate()) times,1800 shijian
union all
select datediff(second,'2020-04-16 15:10:01','2020-04-16 08:40:01') biaozhi,datediff(second,'2020-04-16 15:10:01',getdate()) times,600 shijian
union all
select datediff(second,'2020-04-16 17:15:01','2020-04-16 08:40:01') biaozhi,datediff(second,'2020-04-16 17:15:01',getdate()) times,1800 shijian
) a where biaozhi<1 and times>1