Jump to content

Archived

This topic is now archived and is closed to further replies.

duttydea

Mysql Time Card Calculator

Recommended Posts

How can i adapt this cade to pull the times from  my mysql database?

 

Fields:

Start (Start Time) eg. 06:00:00

Finish (Finish Time) eg. 16:00:00

Lunch ([Either Yes or No] Yes ill deduct an hour from the overall calculation)

 

<?
$lunchflag = false; //true if lunch taken

echo "date 1:" . $datebegin . "<br />";
echo "date 2:" . $dateend . "<br />";

$diff = $dateend - $datebegin;

$hours = floor($diff / (60 * 60));
$minutes = ($diff % (60 * 60)) / 60; //for nice round minutes you can round(), floor() or ceil()

$hours = $lunchflag?$hours - 1:$hours;

echo $hours . ":" . $minutes;
?>

 

Thanks In advance

Share this post


Link to post
Share on other sites

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.