Only a third of shifts have enough nurses on duty, the Royal College of Nursing says its analysis shows.