My father traveled a fair amount for work. It worked out well for us. I didn't realize until I was an adult having parents who loved you and made it obvious they did day to day is so valuable. That matters. Being gone sometimes didn't matter to me, I am sure some days it was annoying and is annoying for other kids. But it is really a minor blip, in my opinion.
