I have this table in my view
duty | exact | undertime
12:00:00 | 12:00:00 | 01:00:00
undertime is the result of $hour = $duty - $exact, and when i
echo date("H:i:s",$hour);
it echoed 01:00:00, im expecting 00:00:00 for this. What did i miss?
here are my code, i use foreach because the duty and exact datas are from my database query.
<?php foreach($unique_date as $unique_dates):?>
<tr>
<td align="center" colspan="2">
<?php echo date($unique_dates['dtr_date']);?>
</td>
<td align="center" colspan="2">
<?php $timediffs = $unique_dates['timediffs'];
echo $timediffs;
?>
</td>
<td align="center" colspan="2">
<?php $exact_total_sched = $unique_dates['exact_total_sched'];
echo $exact_total_sched;
?>
</td>
<?php
$duty = strtotime($timediffs);
$exact = strtotime($exact_total_sched);
?>
<?php
if($duty < $exact)
{
echo "<td align=\"center\" colspan=\"2\">";
#UNDERTIME
$hour1 = $exact-$duty;
echo date("H:i:s",$hour1);
echo "</td>";
echo "<td align=\"center\" colspan=\"2\">";
echo date("00:00:00");
echo "</td>";
}
else if($duty > $exact)
{
echo "<td align=\"center\" colspan=\"2\">";
echo date("00:00:00");
echo "</td>";
echo "<td align=\"center\" colspan=\"2\">";
#OVERTIME
$hour2 = $duty-$exact;
echo date("H:i:s",$hour2);
echo "</td>";
}
else if($duty == $exact)
{
echo "<td align=\"center\" colspan=\"2\">";
$hour3 = $duty-$exact;
echo date("H:i:s",$hour3);
echo "</td>";
echo "<td align=\"center\" colspan=\"2\">";
echo date("00:00:00");
echo "</td>";
}
?>
</tr>
<?php endforeach ?>
You can use DateTime function along with date_diff as
$date1=new DateTime("12:00:00");
$date2=new DateTime("12:00:00");
$diff = date_diff($date2,$date1);
echo $diff->format('%H:%i:%s');
$duty=date_create("12:00:00");
$exact=date_create("12:00:00");
$diff=date_diff($duty,$exact);
echo $diff->format("%H:%i:%s");die;