Database

[{"_id":ObjectId("5f7b3d78e95af70e17efd6d6"),"employeeId":"2707","employeeName":"HrJosh","status":"Present","date":"2020-10-16","clientName":"Lorent","projectName":"ChatBot","taskName":"Learning","durationHrs":"09:30","createdAt":ISODate("2020-10-05T15:36:24.677Z"),"updatedAt":ISODate("2020-10-05T15:36:24.677Z"),"__v":0},{"_id":ObjectId("5f7b5c3de95af70e17efd6d7"),"employeeId":"2707","employeeName":"Gowdham","status":"Present","date":"2020-10-01","clientName":"Lorent","projectName":"ChatBot","taskName":"Meeting","durationHrs":"09:30","createdAt":ISODate("2020-10-05T17:47:41.381Z"),"updatedAt":ISODate("2020-10-05T17:47:41.381Z"),"__v":0},{"_id":ObjectId("5f7b5c62e95af70e17efd6d8"),"employeeId":"2707","employeeName":"Gowdham","status":"Present","date":"2020-10-02","clientName":"fsdsdsd","projectName":"ChatBotsd","taskName":"Manage Team","durationHrs":"09:30","createdAt":ISODate("2020-10-05T17:48:18.994Z"),"updatedAt":ISODate("2020-10-05T17:48:18.994Z"),"__v":0}]

Query

db.collection.aggregate([{$project:{time:{$split:["$durationHrs",":"]}}},{"$project":{totalTime:{$sum:[{"$multiply":[{"$toInt":{"$arrayElemAt":["$time",0]}},60]},{"$toInt":{"$arrayElemAt":["$time",1]}}]}}},{$group:{_id:null,durationHrs:{$sum:"$totalTime"}}},{$project:{durationHrs:{"$concat":[{"$toString":{$toInt:{"$divide":["$durationHrs",60]}}},":",{"$toString":{$mod:["$durationHrs",60]}}]}}}])

Result