What is the best time to sleep, how many hours of sleep are sufficient for an individual, and when does sleep become a waste of time?

The best time to sleep is early at night, after the 'Isha' prayer, and during the time of siesta (qaylulah). The duration varies from person to person, but typically it ranges from six to eight hours on average.