Time for a break from: =CEILING(O5 + TIME(0,K5,0), TIME(0,L5,0)), =FLOOR(N13 - TIME(0,$K$13,0), TIME(0,L13,0)) and this =TEXT(H5, "hh:mm AM/PM") & " - " & TEXT(I5, "hh:mm AM/PM"). Nice 5K should do it. #excel #running - ThreadSky

thomjeff.bsky.social • 24 days ago

Time for a break from:

=CEILING(O5 + TIME(0,K5,0), TIME(0,L5,0)),

=FLOOR(N13 - TIME(0,$K$13,0), TIME(0,L13,0)) and this

=TEXT(H5, "hh:mm AM/PM") & " - " & TEXT(I5, "hh:mm AM/PM").

Nice 5K should do it. #excel #running