To enjoy everything the New York Aquarium has to offer, plan to spend between 2 and 2.5 hours.
While all visitors are required to have a date-specific ticket for entry, you can stay as long as you'd like during the regular hours of operation (which can vary depending on the season).