[{"_id":ObjectId("6087fc6de0232d5008224032"),"createTime":ISODate("2021-04-27T11:30:09.000Z"),"statusDetails":[{"createTime":ISODate("2021-04-28T05:56:44.000Z"),"createUser":"operations@cis.com.pk","stateOccurTimeStr":"2021-04-28 12:56:44","status":27,"statusDesc":"Shipped"}]},{"_id":ObjectId("6087fc6de0232d5008224033"),"createTime":ISODate("2021-04-27T11:30:09.000Z"),"statusDetails":[{"createTime":ISODate("2021-04-28T05:57:12.000Z"),"createUser":"operations@cis.com.pk","stateOccurTimeStr":"2021-04-28 12:57:12","status":27,"statusDesc":"Shipped"}]},{"_id":ObjectId("6087b39ae858193006246112"),"createTime":ISODate("2021-04-27T05:57:03.000Z"),"statusDetails":[{"createTime":ISODate("2021-04-28T06:40:41.000Z"),"createUser":"haider.badat@cis.com.pk","stateOccurTimeStr":"2021-04-28 13:40:41","status":27,"statusDesc":"Shipped"}]},{"_id":ObjectId("6087b39ae858193006246119"),"createTime":ISODate("2021-04-27T05:57:03.000Z"),"statusDetails":[{"createTime":ISODate("2021-04-28T06:30:11.000Z"),"createUser":"haider.badat@cis.com.pk","stateOccurTimeStr":"2021-04-28 13:30:11","status":27,"statusDesc":"Shipped"}]},{"_id":ObjectId("6087b39ae85819300624611d"),"createTime":ISODate("2021-04-27T05:57:03.000Z"),"statusDetails":[{"createTime":ISODate("2021-04-28T06:34:57.000Z"),"createUser":"haider.badat@cis.com.pk","stateOccurTimeStr":"2021-04-28 13:34:57","status":27,"statusDesc":"Shipped"}]},{"_id":ObjectId("6087b39ae85819300624611e"),"createTime":ISODate("2021-04-27T05:57:03.000Z"),"statusDetails":[{"createTime":ISODate("2021-04-28T06:29:47.000Z"),"createUser":"haider.badat@cis.com.pk","stateOccurTimeStr":"2021-04-28 13:29:47","status":27,"statusDesc":"Shipped"}]},{"_id":ObjectId("6087b39ae858193006246120"),"createTime":ISODate("2021-04-27T05:57:03.000Z"),"statusDetails":[{"createTime":ISODate("2021-04-28T06:38:22.000Z"),"createUser":"haider.badat@cis.com.pk","stateOccurTimeStr":"2021-04-28 13:38:22","status":27,"statusDesc":"Shipped"}]},{"_id":ObjectId("6087b39ae858193006246121"),"createTime":ISODate("2021-04-27T05:57:03.000Z"),"statusDetails":[{"createTime":ISODate("2021-04-28T06:30:18.000Z"),"createUser":"haider.badat@cis.com.pk","stateOccurTimeStr":"2021-04-28 13:30:18","status":27,"statusDesc":"Shipped"}]},{"_id":ObjectId("6087b39ae858193006246124"),"createTime":ISODate("2021-04-27T05:57:03.000Z"),"statusDetails":[{"createTime":ISODate("2021-04-28T06:34:28.000Z"),"createUser":"haider.badat@cis.com.pk","stateOccurTimeStr":"2021-04-28 13:34:28","status":27,"statusDesc":"Shipped"}]},{"_id":ObjectId("6087fc6de0232d5008224034"),"createTime":ISODate("2021-03-29T11:30:09.000Z"),"statusDetails":[{"createTime":ISODate("2021-03-30T12:57:12.000Z"),"createUser":"operations@cis.com.pk","stateOccurTimeStr":"2021-03-30 12:57:12","status":27,"statusDesc":"Shipped"}]}]

db.collection.aggregate([{$unwind:"$statusDetails"},{$match:{"statusDetails.status":27}},{$addFields:{slot:{$multiply:[{$floor:{$divide:[{$abs:{"$divide":[{$subtract:["$statusDetails.createTime","$createTime"]},3600000]}},4]}},4]}}},{$group:{_id:{date:{$dateToString:{date:"$createTime",format:"%d-%m-%Y"}},slot:"$slot"},total:{$sum:1}}},{$sort:{"_id.slot":1}},{$group:{_id:"$_id.date",hours:{$push:{slot:"$_id.slot",total:"$total"}},totalOrders:{$sum:"$total"}}}])