Hello,

I am using the following formula to calculate time in military format but it is not providing the desired results:

=(TRUNC(C2/100)-TRUNC(B2/100))/24+(MOD(C2,100)-MOD(B2,100))/1440+IF(C2<B2,1)

I have attached the file for assistance.

Thanks a bunch.Start & Stop In Military Time.xlsx