Antwort
Du suchst sowas?
Mehr dazu hier: https://www.excelforum.com/excel-general/662794-timecode-cell-formula.html
=TEXT(LEFT(B2,8)-LEFT(A2,8)-(RIGHT(A2,2)>RIGHT(B2,2))/86400,"m:ss")&TEXT(MOD(RIGHT(B2,2)-RIGHT(A2,2),24),"\:00")