import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;

public class POI_test {

	public static void main(String[] args) throws FileNotFoundException,
			IOException {
		getSumTimes();
	}

	public static void getSumTimes() throws FileNotFoundException, IOException {
		// 得到Excel常用对象
		POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream(
				"f:/yidong.xls"));
		// 得到Excel工作簿对象
		HSSFWorkbook wb = new HSSFWorkbook(fs);
		// 得到Excel工作表对象
		HSSFSheet sheet = wb.getSheetAt(0);
		int maxRowNums = sheet.getLastRowNum();
		int second = 0;
		int minute = 0;
		int hour = 0;
		for (int i = 1; i < maxRowNums; i++) {
			// 得到Excel工作表的行
			HSSFRow row = sheet.getRow(i);
			// 得到Excel工作表指定行的单元格
			HSSFCell cell = row.getCell(4);
			String time = cell.getStringCellValue();
			for (int j = time.length() - 1; j >= 0; j--) {
				if (time.charAt(j) == '秒') {
					StringBuffer se = new StringBuffer();
					for (int k = j - 1; k >= 0 && time.charAt(k) >= 48
							&& time.charAt(k) <= 57; k--) {
						se.append(time.charAt(k));
					}
					se.reverse();
					int se_int = Integer.parseInt(se.toString());
					second += se_int;
				}
				if (time.charAt(j) == '分') {
					StringBuffer min = new StringBuffer();
					for (int k = j - 1; k >= 0 && time.charAt(k) >= 48
							&& time.charAt(k) <= 57; k--) {
						min.append(time.charAt(k));
					}
					min.reverse();
					int min_int = Integer.parseInt(min.toString());
					minute += min_int;
				}
				if (time.charAt(j) == '时') {
					StringBuffer hou = new StringBuffer();
					for (int k = j - 1; k >= 0 && time.charAt(k) >= 48
							&& time.charAt(k) <= 57; k--) {
						hou.append(time.charAt(k));
					}
					hou.reverse();
					int hour_int = Integer.parseInt(hou.toString());
					hour += hour_int;
				}
			}
		}
		minute = minute + second / 60;
		second = second % 60;
		hour = hour + minute / 60;
		minute = minute % 60;
		System.out.println("总通话时间为：" + hour + " 小时  " + minute + " 分钟 "
				+ second + " 秒 ");
	}
}