I need a PHP function to calculate time periods

[eliasskate_8]

Can someone can help me to create a php function that calculates time between two dates excluding break, lunches, and weekends

function timeinqueue()
{
}

[Rubble]

I do not think it works like that @eliasskate_8 you have to put a bit more effort in than you have posted. You should be able to calculate the time between two dates removing the breaks and lunches. Start with that and you can come back and ask about how to work in the weekend part…

[Gandalf]

function timeinqueue($startDate, $endDate)
{
}

Your go.

[eliasskate_8]

yeha i know ho to calculated time between two but here is my problem I have a basic knowledge of programming i create a scanning system when a work order is scanning type in in a certain location is my $start time and when they scanning type out is my $end that gives me a time between those day and just by extract the breaks but what about if they scan type in a work order Friday at 4:30 and scan type out Monday at 8:00 it will count Saturday and Sunday.

here what i got so far.

function timequeue($start, $end)
{
$ptime = $start->diff($end);
$output = $ptime->format(' %d Days, %h Hours : %i Minutes');

echo $output;

}

[eliasskate_8]

i get to this point but Saturdays and Sundays won’t work

@Rubble

<?php function get_working_hours($from,$to) { $from_timestamp = strtotime($from); $to_timestamp = strtotime($to); $workday_start_hour = 6; $workday_end_hour = 16; $workday_seconds = ($workday_end_hour - $workday_start_hour)*3600; $from_date = date('Y-m-d',$from_timestamp); $to_date = date('Y-m-d',$to_timestamp); $workdays_number = count(get_workdays($from_date,$to_date)); $workdays_number = $workdays_number<0 ? 0 : $workdays_number; $start_time_in_seconds = date("H",$from_timestamp)*3600+date("i",$from_timestamp)*60; $end_time_in_seconds = date("H",$to_timestamp)*3600+date("i",$to_timestamp)*60; $working_hours = ($workdays_number * $workday_seconds + $end_time_in_seconds - $start_time_in_seconds) / 86400 * 24; return $working_hours; } <?php function get_workdays($from,$to) { $days_array = array(); $skipdays = array("Saturday", "Sunday"); $skipdates = get_holidays(); // other variables $i = 0; $current = $from; if($current == $to) // same dates { $timestamp = strtotime($from); if (in_array(date("l", $timestamp), $skipdays)&&in_array(date("Y-m-d", $timestamp), $skipdates)) { $days_array[] = date("Y-m-d",$timestamp); } } elseif($current < $to) // different dates { while ($current < $to) { $timestamp = strtotime($from." +".$i." day"); if (!in_array(date("l", $timestamp), $skipdays) && !in_array(date("Y-m-d", $timestamp), $skipdates)) { $days_array[] = date("Y-m-d",$timestamp); } $current = date("Y-m-d",$timestamp); $i++; } } return $days_array; } ?> <?php function get_holidays() { $days_array = array(); return $days_array; } ?>

[chorn]

Could you provide a well formatted code? The way you posted it contains some serious syntax errors. Some example and expected output would make it easier for your helpers to get into the topic.

[droopsnoot]

Does this older thread provide any useful ideas? Calculate the number of working day hours between two dates - #4 by Drummin

[eliasskate_8]

Thanks guy for the help i made it work