MS Access：汇总时间大于24小时的查询再次从1重新开始

我希望此SQL查询有帮助：

SELECt T.UID,       CSTR(total_hours      + INT(total_min / 60))      + ":"      + CSTR(total_min Mod 60) as resultFROM    (SELECt UID, SUM(HOUR(TH.time_elapsed)) AS total_hours, SUM(MINUTE(TH.time_elapsed)) AS total_min    FROM trans_hist AS TH    GROUP BY UID) AS T