
Originally Posted by
Glenn Kennedy
Next time, please upload an Excel file, instead of a non-editable picture of one. It saves us (me) having to recreate what you have right in front of you.
=TEXTJOIN(CHAR(10),,TEXT(TEXTSPLIT(B2,,CHAR(10))-TEXTSPLIT(A2,,CHAR(10)),"hh:mm:ss"))
Bookmarks