Is there any mention of the minimum or maximum number of sleeping hours for humans in Vedas, Puranas, Ayurveda, or any other scriptures?
You should wake up before sunrise, and go to sleep after sunset. Here is what this chapter of the Manu Smriti says:
If the sun should rise or set while he is sleeping, be it (that he offended) intentionally or unintentionally, he shall fast during the (next) day, muttering (the Savitri). For he who lies (sleeping), while the sun sets or rises, and does not perform (that) penance, is tainted by great guilt.
And here is what this chapter of the Gauatama Dharma Sutras says:
Let him who was asleep when the sun rose remain standing during the day, continent and fasting, and him who was asleep when the sun set (remain in the same position) during the night, reciting the Gâyatrî.
The answer is not directly mentioned in Puranas, but one can find a small hint in Shrimad Devi Bhagwatam Mahapuran. It's from the 1st Skandha, 17th Chapter when, Sukadev goes to meet Maharaj Janaka in Mithila. The routine he follows at Janaka Mahal,is mentioned.
The verses are as follows,
स कृत्वा पादशौचं च कुशपाणिरतन्द्रेतः।
उपास्य पश्चिमां सन्ध्याम् ध्यानमेवान्वपघत।।६४
He, then, washed his feet and with vigilance, put on his finger the ring prepared of Kuśa grass, and completing his evening Sandhyā, became merged in Dhyāna.
यामेकंस्थितो ध्याने सुश्वाप तदनन्तरम्।
सुप्तवा यामद्वायं तत्र चोदतिष्ठ न्त तः शुकह्।।६५
Meditating on Supreme Brahmā for one Prahara (three hours), slept for 2 Prahara (6 hours) and getting up, again became merged in Brahmā Dhyāna, in the last 1 Prahara (three hours) of the night.
पाश्चात्यम् यामिनीयामं ध्यानमेवान्वपघत।
स्नात्वा प्रातः क्रियाः कृत्वा पुनरास्ते समाहितः।।६६
Then in morning, he took his bath and completing his morning duties, became immersed in Samādhi (inner enlightenment) and sat at ease.
From this, a conclusion can be drawn. Suppose the Sandhya is done by 6 in evening, till 9 sukhdevji was in dhyan. Then he slept for 6 hours,that is 9 to 3, and did dhyan for 3 hours, that is probably 3 to 6 which are also the last prahar of night as aforementioned in shlokas. Thereafter, he had his snan in morning, did his proper duties, i.e. Sandhyavandana and after that he got engrossed in dhyana,and than he sat at ease that is, he relaxed down