I took a close look and found an issue that fixed my original problem. However, fixing that caused another issue to come to the surface. Look at the attached Excel and you will see:
[code]
=(IF(G11>=B16,(G11/B9)*60+B18,G11/B9*60))
[\code]
In cell G18. When G11 is greater or equal to b16 then the formula should be adding 15 and 10 for a total of 25.
Bookmarks