45 min on Lufthansa!
A friend was flying LH on a CAI-FRA-SFO itinerary with an upset stomach. He took some mild all-purpose sedative at the beginning of the FRA-SFO flight, but it knocked him out, unfortunately while he was in the lav. One of the LH flight attendants opened the door and helped him out after about 45 minutes. He was fine once he got back on the ground.
-Hayden