Military Time Not Calculating after Midnight.

Originally Posted by daddylonglegs

Presumably actual time could be early as well as late? These questions are always difficult because of the circular nature of time (for your example 03:00 could be 19 hours early rather than 5 late), so you need to make some assumptions.

Let's assume that actual arrival time will never be more than 2 hours early (adjust as required) and use this formula for thee number of minutes late

=IF(MOD(F5-E5+"2:00",1)-"2:00">0,MOD(F5-E5,1)*1440,0)

Thanks for the help, Im not familiar with this MOD function so hard for me to troubleshoot...but this returned a value of 432000 when it should be 300 (5 hours in min)