user: ### NOW ANSWER:
Question: What is the total time in office of the prime minister from the Liberal party and left office in 19 December 1967?
Columns: ['Rank:', 'Prime Minister:', 'Party:', 'Assumed Office:', 'Left Office:', 'TOTAL Time in Office:']
Types: ['real', 'text', 'text', 'text', 'text', 'text']
Sample row: [1.0, 'Sir Robert Menzies (1894–1978)', 'United Australia', '26 April 1939', '29 August 1941', '18 years, 160 days']
SQL:

assistant: SELECT "TOTAL Time in Office:" FROM "Table" WHERE "Party:" = 'Liberal' AND "Left Office:" = '19 December 1967';