calculate total time?

nikko50

Hi dudes.
If I have a START_DATE and START_TIME and a END_DATE and END_TIME and I then want to remove the time spent at LUNCH how can calculate the total time worked??

START TIME 05/05/2011 10:53:39
LUNCH OUT 05/05/2011 10:54:06
LUNCH IN 05/05/2011 10:54:43
END TIME 05/05/2011 19:17:44

bradgrafelman

Is this data coming from a database (e.g. MySQL) by any chance?

nikko50

Yes it is. mysql

bradgrafelman

If that's the case then simply use MySQL's TIMESTAMPDIFF() function to get the number of minutes (or seconds) between the start of lunch and the beginning time, and then add the difference between the ending time and the end of lunch.

Undrium

bradgrafelman is right, I have, though bumped into this alot lately. So here is a solution without using MYSQL.

$start = strtotime("05/05/2011 10:53:39");
$lunchstart = strtotime("05/05/2011 10:54:06");
$lunchend = strtotime("05/05/2011 10:54:43");
$end = strtotime("05/05/2011 19:17:44");

$worktime = ($end - $start) - ($lunchend-$lunchstart);

$hours = intval($worktime / 3600);  

$secs_left = ($worktime - ($hours * 3600));

$minutes = intval($secs_left / 60);  

$seconds = ($secs_left - ($minutes * 60));

echo "$hours:$minutes:$seconds";

Bear in mind that this can be shortened alot, also the date format is "mm/dd/yyyy".

nikko50

AWESOME.