title: How to use sheets.spreadsheets.batchUpdate() to apply formatting?
body: <p>I am attempting to automatically apply new formatting to my spreadsheet, however while it does not appear to cause any errors, it is not working.</p>
  
  <p>My goal is to apply duration formatting to columns G and H (index 6 and 7) of my spreadsheet. I am automatically updating the spreadsheet with string data in the format without brackets:</p>
  
  <pre><code>[D]:[H]:[M]
  </code></pre>
  
  <p>Where D, H, and M may be single or double digit. I would like it to display in the following format without brackets on the spreadsheet:</p>
  
  <pre><code>[hh]:[mm]:[ss]
  </code></pre>
  
  <p>Where there is always at least two digits in each column. However, the spreadsheet seems to automatically choose formatting regardless of what formatting I request, and it chooses a decimal number format. How can I use the batchUpdate() function to apply a working duration formatting to just these two columns?</p>
  
  <p>My Code attempt is below. I am using the Node.js Google API Client Library.</p>
  
  <pre><code>sheets.spreadsheets.batchUpdate({
    spreadsheetId: '1AakOf_W90JdAtL0R8XeMmacWrnBx8wLKrMCdHdnNmhM',
  
    resource: {
      requests: [{
        updateCells:{
          range: {
            startColumnIndex: 6,
            endColumnIndex: 8
          },
          'fields': 'userEnteredFormat/numberFormat(pattern,type),effectiveFormat/numberFormat(pattern,type)',
            rows:[{
              values:[{
                userEnteredFormat:{
                  numberFormat:{
                    pattern: '[hh]:[mm]:[ss]',
                    type: 'TIME'
                  }
                },
                effectiveFormat:{
                  numberFormat:{
                    pattern: '[hh]:[mm]:[ss]',
                    type: 'TIME'
                  }
                }
              }]
            }]
          }
        }
      ]
    }
  }, function(err, response, responseBody){
    if(err){
      console.log(err);
      console.log(err.code);
    }
  });
  </code></pre>