79300854

Date: 2024-12-22 10:58:23
Score: 1
Natty:
Report link

An alternastive, using QUERY function;

=ARRAYFORMULA(QUERY({C2:E,TIMEVALUE(E2:E)-TIMEVALUE(D2:D)},"Select Col1, Max(Col4) Where Col1 Is Not Null Group By Col1 Label Col1 'DATE', Max(Col4) 'MAX TIME' Format Max(Col4) 'HH:MM'"))

.

enter image description here

Reasons:
  • Probably link only (1):
  • Low length (0.5):
  • Has code block (-0.5):
Posted by: Haluk