Report Offensive Message

All,

Someone on Mr Excel helped me with the formula for working past midnight some time ago
Here is the formula: =ROUND((MOD(G2-D2,1)-MOD(F2-E2,1))*24,1)
Tested for several different scenarios, worked for every test case. You will need to enter all times in Military time (24:00) Ex: 12 midnight = 00:00, 8am = 08:00, 2pm = 14:00 (12+2)