It depends on several variables including the material, the moisture content, how often it is turned, etc.
For cow manure, I generally work it for about 6 months before using as compost mainly because I want to kill all pathogens and weed seeds.... about the same for chicken. The "books" say you can safely use it in weeks if you achieve adequate temps while composting. I do achieve the right temps but generally have plenty of supply so it doesn't get used for about 6 months.
I like to see it hit about 135 deg f just under the surface and measure to make sure while composting. To get that, you generally have to turn/mix it every week. It steams and throws off amazing heat when turned. The result is an odor free completely safe product.
For legumes, I generally compost them in place and plant in the bed/row in a couple of weeks.
For household stuff, yard waste, kitchen scraps, etc., I could use the compost within a month, but I always have such a large supply that it generally sits considerably longer than that. I’ve also been checking out some
Craigslist reviews to see if there are any tips on composting from other users who deal with large quantities.
Frequent turning/mixing and adequate moisture are important in timely composting.
The very best compost I have created as measured by lab tests has been composted cow manure layered with the best green legume (sun hemp in my case). I make the layers in large tubs and keep them covered to minimize nitrogen loss and any other nutrient loss. If using composted manure, the addition of layers of legume (to boost nitrogen) takes less than a month to be fully composted and ready to go to work in your garden.