[{"_id":ObjectId("62debcb8666e8a64c2ae5e18"),"attendanceDate":"07/25/2022","displayName":"John, Doe","signInDate":ISODate("2022-07-25T15:54:32.117Z"),"currentStatus":"Training","currentStatusTime":ISODate("2022-07-25T18:45:23.574Z"),"history":[{"status":"Training","startTime":ISODate("2022-07-25T18:45:23.573Z"),"endTime":ISODate("2022-07-25T18:47:23.574Z")},{"status":"In","startTime":ISODate("2022-07-25T17:56:08.236Z"),"endTime":ISODate("2022-07-25T18:45:23.574Z")},{"status":"Training","startTime":ISODate("2022-07-25T16:25:25.133Z"),"endTime":ISODate("2022-07-25T17:56:08.238Z")},{"status":"In","startTime":ISODate("2022-07-25T16:05:57.791Z"),"endTime":ISODate("2022-07-25T16:25:25.134Z")},{"status":"Meeting","startTime":ISODate("2022-07-25T16:02:43.956Z"),"endTime":ISODate("2022-07-25T16:05:57.796Z")},{"status":"In","startTime":ISODate("2022-07-25T16:00:07.308Z"),"endTime":ISODate("2022-07-25T16:02:43.956Z")},{"status":"Break","startTime":ISODate("2022-07-25T15:58:12.798Z"),"endTime":ISODate("2022-07-25T16:00:07.309Z")},{"status":"In","startTime":ISODate("2022-07-25T15:55:00.489Z"),"endTime":ISODate("2022-07-25T15:58:12.798Z")}]}]

db.collection.aggregate([{$match:{attendanceDate:"07/25/2022"}},{$unwind:"$history"},{$set:{timeDiff:{$dateDiff:{startDate:"$history.startTime",endDate:"$history.endTime",unit:"minute"}}}},{$group:{_id:{status:"$history.status",displayName:"$displayName"},duration:{$sum:"$timeDiff"}}},{$group:{_id:"$_id.displayName",durations:{$push:{key:"$_id.status",value:"$duration"}}}}])