Figuring total hours in military time going passed midnight.

I am trying to calculate a revised ETA for a truck to appear. See below. All downstream ETAs are calculated based on the time above (for example, if revised ETA for first stop is early, the downstream ETAs for that route should auto-calculate). If revised ETA is early and crosses midnight, the calculations for the revised ETA do not work. Any suggestions? Thanks! Kim

Please Login or Register  to view this content.