Challenge #68: Elapsed Classroom Times

[ainderike]

I usually try to avoid multilayer formulas, so I tried to split it into digestible pieces. 

Spoiler

[Qusaiamer]

The goal was to use one formula for everything but the time difference beat me. Any clue how to take difference between two time inputs (in string type) using formula? Also sorry couldn't do the spoiler thing!

[swlsherry]

SOLN

[ahmed1]

my solution

[fsnunes]

My Answer

[scoles0617]

My solution:

[wcarlson99]

Here it is

[Bergy]

Time is relative. I have a bunch of tools but it is a clear solution.

[Diederik_vanderharst]

Took a little time to get it precisely right, but here it is. Voila.

Spoiler

 

[leonhekkert]

My solution!

Spoiler