I think it depends on your physical condition and exercise intensity. Low intensity activity can be maintained for a long time, the higher the intensity, the less time you can sustain the effort. Training allows you to sustain a higher intensity, for a longer period of time.
Hiking is one of my favorite activities, and we'll do a 15 miler day hike over a period of 7 or 8 hours. Or think nothing of kayaking for 4 hours. You have to be in shape for it, fuel appropriately, and go at a pace that is moderate and sustainable for you.
<warning, rant mode on>
C'mon people, humans used to work out in the fields, HARD, all day long!! They had to chop wood, pump water, milk the cows, and that was before breakfast. We are built for work, we've just gotten so sedentary as a society, that now we have to start slow and work ourselves up to it. Now we think that working our muscles hard for 2 hours is excessive? Our perspective has certainly changed.
Sorry -- hot button topic for me .... rant mode off.
