<table class="table table-striped table-bordered table-hover" id="dataTables-example">
<thead>
<tr>
<th width="34" rowspan="2" class="center">No</th>
<th width="34" rowspan="2" class="center">FingerPrintID</th>
<th width="137" rowspan = "2" class="center">EmployeeID</th>
<th width="137" colspan = "2" class="center">Jam Masuk</th>
<th width="137" colspan = "2" class="center">Jam Keluar</th>
<th width="160" colspan = "2" class="center">Terlambat</th>
<th width="230" colspan = "2" class="center">Cepat Pulang</th>
</tr>

<tr>
<th scope="col">Jam</th>
<th scope="col">Menit</th>
<th scope="col">Jam</th>
<th scope="col">Menit</th>
<th scope="col">Jam</th>
<th scope="col">Menit</th>
<th scope="col">Jam</th>
<th scope="col">Menit</th>
</tr>


</thead>

<tbody>

<?php

$cek1 = '07:00:00';
$cek2= '16:00:00';

$query = mysql_query("Select id, FingerPrintID, EmployeeID, min(TimeLog) as Absensi_Masuk, max(TimeLog) as Absensi_Keluar,
timediff(TimeLog,'$cek1' ) as SelisihMasuk, timediff(Timelog,'$cek2') as SelisihKeluar from siswa
Group by FingerPrintID, EmployeeID");

$no=1;

while($row=mysql_fetch_array($query)){

$time1 = $row['Absensi_Masuk'];
$waktu1 = explode(":", $time1);

$time2 = $row['Absensi_Keluar'];
$waktu2 = explode(":", $time2);

$Selisih1 = $row['SelisihMasuk'];
$Masuk1 = explode(":", $Selisih1);

$Selisih2 = $row['SelisihKeluar'];
$Masuk2 = explode(":", $Selisih2);


//query untuk database
//menampilkan hasil query dalam bentuk array

?>
<tr class="odd gradeX">
<td><?php echo $no;?></td>
<td><?php echo $row['EmployeeID']?></td>
<td><?php echo $row['FingerPrintID']?></td>
<td><?php echo $waktu1[0];?></td>
<td><?php echo $waktu1[1];?></td>

<td><?php echo $waktu2[0];?></td>
<td><?php echo $waktu2[1];?></td>

<td><?php echo $Masuk1[0]?></td>
<td><?php echo $Masuk1[1]?></td>

<td><?php echo $Masuk2[0]?></td>
<td><?php echo $Masuk2[1]?></td>
</tr>

<?php $no++ ; } ?>
<tr>
<td colspan="3">Jumlah</td>
</tr>
</tbody>

</table>