Question: how to calculate difference between two military times in excel?
Answer: Write the formula in cell C2.
=(TEXT(B2,"00\:00")-TEXT(A2,"00\:00"))*24.
The function will return the break timing in between the pairs of times.