1

=ARRAYFORMULA(REGEXREPLACE(REGEXREPLACE(REGEXREPLACE(TEXTJOIN(CHAR(10), 1, QUERY(TRANSPOSE("♦"&QUERY(FILTER('Source table'!$A$2:$G$6,'Source table'!$A$2:$A$6=$B3), "select Col2,Col3,':',Col4,Col5,Col6 label ':'''")),,999^99)), "♦", CHAR(10)), "^"&CHAR(10), ), " "&CHAR(10)&": "&CHAR(10), ": "))


1

If this is a time you should enter it as: 01:00:00 and format it like: And then you will just use simple SUM(A1:A2):


Only top voted, non community-wiki answers of a minimum length are eligible