duttydea Posted October 7, 2008 Share Posted October 7, 2008 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 Link to comment https://forums.phpfreaks.com/topic/127429-mysql-time-card-calculator/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.