è·åå
¬å¼å¼å¯ç¨ HSSFFormulaEvaluator e= New HSSFFormularEvaluator(workbook);
e.evaluate(cell).getNumberiValue.
å¦æä¸æ¯ä½ è¦çç»æãè¿æå
¶å®å¾å¤æ¹æ³ã
æ¯å¦è¿æ ·ä¸ä¸ªæ¯è¾ç¬¨çæ¹æ³ã
double value = cell.getNumericCellValue();
value = value * 24 *3600;
int h = (int) (value /3600)
int m= (int )((value - h* 3600) /60);
int s = (int)(value-h*3600 -m* 60) ;
String result = h + ":"+m + "s" ;
å¾å°ç»æã
ææºæåï¼æ ¼å¼å°å°±çå§ã
温馨提示:答案为网友推荐,仅供参考