24 hour clock formula for elapsed time between 1215 and 1630

S

Sheeloo

With 16:30 in A1 and 12:15 in B1, put this in C1
=A1-B1
to get the difference 4:15
 
Top