In our Agreement, is there a provision for time off for a medical appointment?

No, there is no identified leave for medical and/or dental appointments. M&P staff are expected to coordinate appointments that do not adversely affect business operations and should discuss with their manager or supervisor flexible working arrangements should it be required.