Shoah, its around 9 hours.

Longest film I saw in a cinema was Satantango around 7 1/2 hours. Had a couple of intermissions.

There are much longer movies out there but now Im older I just don't have the time.