You can drive the Scenic Loop Drive and explore the overlooks in a couple of hours. If you plan on hiking the trails or climbing the formations, allow for more time in the park. Read the full guide here: https://travelrealist.com/red-rock-canyon-national-area-us/