Database
[{id:1,name:"abch",start:"12:00 pm",end:"03:00 pm"},{id:2,name:"Annabelle",start:"08:30 am",end:"10:00 am"},{id:3,name:"Spider Man homecoming",start:"11:30 am",end:"03:00 pm"},{id:4,name:"Grudge",start:"10:00 pm",end:"00:00 am"}]
Query
db.collection.aggregate([{$set:{startHour:{$add:[{$mod:[{$toInt:{$substr:["$start",0,2]}},12]},{"$divide":[{$toInt:{$substr:["$start",3,2]}},60]},{$cond:[{$eq:[{$substr:["$start",6,2]},"am"]},0,12]}]},startingHour:{$add:[{$mod:[{$toInt:{$substr:["12:00 pm",0,2]}},12]},{"$divide":[{$toInt:{$substr:["12:00 pm",3,2]}},60]},{$cond:[{$eq:[{$substr:["12:00 pm",6,2]},"am"]},0,12]}]},endingHour:{$add:[{$toInt:{$substr:["00:00 am",0,2]}},{"$divide":[{$toInt:{$substr:["00:00 am",3,2]}},60]},{$cond:[{$eq:[{$substr:["00:00 am",6,2]},"am"]},0,12]}]},endHour:{$add:[{$toInt:{$substr:["$end",0,2]}},{"$divide":[{$toInt:{$substr:["$end",3,2]}},60]},{$cond:[{$eq:[{$substr:["$end",6,2]},"am"]},0,12]}]}}},{$set:{endHour:{$cond:[{$eq:["$endHour",0]},24,"$endHour"]},endingHour:{$cond:[{$eq:["$endingHour",0]},24,"$endingHour"]}}},{$match:{$expr:{$and:[{$gte:["$startHour","$startingHour"]},{$lte:["$endHour","$endingHour"]}]}}},{$unset:["stasrtHour","endHour","startingHour","endingHour"]}])