How long does the paint in the palette last?

It's very individual. If you use high-quality companies and highly pigmented paints, then with one addition of paints to the palette you can fill the entire sketchbook with paintings.