For some reason I cannot make some of these formula's work, it appears to do the same thing around the 2 hour threshold. One minute over or under the 2 hour threshold and it works well. Exactly 2 hours appears to be difficult for excel. When I changed the formula for I14, it did not calculate any values at any point. Excel gives the error message “error in value” for the formula in J14 as well. I changed the formula’s, formatting and copied down. I may be doing something wrong.
Thanks,
Russ