title: Setting Time in Excel using POI
body: <p>I am trying to create an Excel Work sheet using POI api in Java. In that Excel Work Sheet I want to have a cell with TIME alone. By setting this we can include the cell in summation of that particuluar column as we do in number columns. For this we need to format the cell as Time >> 13:30:55. (The internal format is 'h:mm:ss;@' ). And we need to remove the date part from the cell. </p>
  
  <p>When I read the cell the cell value using the POI, it is returning as 'Sun Dec 31 01:00:00 IST 1899' ( When i set the value as 1:00 ), the cell format index is 166 and the cell format string is 'h:mm:ss;@'.</p>
  
  <p>After setting the formats and style which were read from the excel and the cell value as 1800-December-31 and with the time value, the new excel shows cell as '######' (error) and cell value is setted as '-1'. Below is the code I have used. Did I miss anything ? Is it possible to set the value as I required.</p>
  
  <pre><code>    InputStream is = new BufferedInputStream(new FileInputStream("&lt;FileName&gt;"));
      XSSFWorkbook wb = new XSSFWorkbook(is);
      is.close();
  
      XSSFSheet sheet = wb.getSheetAt(0);
      XSSFRow row = sheet.getRow(2);
  
      XSSFCell cell = row.getCell(18);
      System.out.println("ExcelFileReader main cell.getDateCellValue() : '" + cell.getDateCellValue() + "'");
      System.out.println("ExcelFileReader main cell.getCellStyle().getDataFormat() : '" + cell.getCellStyle().getDataFormat() + "'");
      System.out.println("ExcelFileReader main cell.getCellStyle().getDataFormat() : '" + cell.getCellStyle().getDataFormatString() + "'");
  
      XSSFRow row1 = sheet.createRow(21);
      XSSFCell cell1 = row1.createCell(2);
  
      cell1.setCellStyle(cell.getCellStyle());
      cell1.setCellValue(cell.getDateCellValue());
  
      Calendar dummy = Calendar.getInstance();
      dummy.setLenient(false);
      dummy.set(Calendar.YEAR, 1899);
      dummy.set(Calendar.MONTH, Calendar.DECEMBER);
      dummy.set(Calendar.DATE, 31);
  
      dummy.set(Calendar.HOUR, 00);
      dummy.set(Calendar.MINUTE, 00);
      dummy.set(Calendar.SECOND, 00);
      dummy.set(Calendar.MILLISECOND, 00);
  
      Calendar cc = Calendar.getInstance();
      XSSFRow row2 = sheet.createRow(25);
      XSSFCell cell2 = row2.createCell(2);
  
      dummy.set(Calendar.HOUR, cc.get(Calendar.HOUR));
      dummy.set(Calendar.MINUTE, cc.get(Calendar.MINUTE));
      dummy.set(Calendar.SECOND, cc.get(Calendar.SECOND));
      dummy.set(Calendar.MILLISECOND, cc.get(Calendar.MILLISECOND));
  
      System.out.println("ExcelFileReader main dummy : '" + dummy.getTime() + "'");
      cell2.setCellValue(dummy.getTime());
  
      CellStyle style = wb.createCellStyle();
      DataFormat df = wb.createDataFormat();
      style.setDataFormat(df.getFormat("[h]:mm:ss;@"));
      cell2.setCellStyle(style);
  
      FileOutputStream fos = new FileOutputStream(new File("&lt;New Excel file&gt;"));
      wb.write(fos);
      fos.close();
      System.out.println("ExcelFileReader DONE");
  </code></pre>
  
  <p>The following is the output of the program.</p>
  
  <pre><code>    ExcelFileReader main cell.getDateCellValue() : 'Sun Dec 31 00:15:00 IST 1899'
      ExcelFileReader main cell.getCellStyle().getDataFormat() : '166'
      ExcelFileReader main cell.getCellStyle().getDataFormat() : 'h:mm:ss;@'
      ExcelFileReader main dummy : 'Sun Dec 31 11:32:24 IST 1899'
      ExcelFileReader DONE
  </code></pre>