Databases
StackOverflow2013
Postsdbo
POcalc the working hours between 2 dates in PHP
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POcalc the working hours between 2 dates in PHP
    primarykey
    data
    text
    <p>I have a function to return the difference between 2 dates, however I need to work out the difference in working hours, <strong>assuming Monday to Friday (9am to 5:30pm):</strong></p> <pre><code>//DATE DIFF FUNCTION // Set timezone date_default_timezone_set("GMT"); // Time format is UNIX timestamp or // PHP strtotime compatible strings function dateDiff($time1, $time2, $precision = 6) { // If not numeric then convert texts to unix timestamps if (!is_int($time1)) { $time1 = strtotime($time1); } if (!is_int($time2)) { $time2 = strtotime($time2); } // If time1 is bigger than time2 // Then swap time1 and time2 if ($time1 &gt; $time2) { $ttime = $time1; $time1 = $time2; $time2 = $ttime; } // Set up intervals and diffs arrays $intervals = array('year','month','day','hour','minute','second'); $diffs = array(); // Loop thru all intervals foreach ($intervals as $interval) { // Set default diff to 0 $diffs[$interval] = 0; // Create temp time from time1 and interval $ttime = strtotime("+1 " . $interval, $time1); // Loop until temp time is smaller than time2 while ($time2 &gt;= $ttime) { $time1 = $ttime; $diffs[$interval]++; // Create new temp time from time1 and interval $ttime = strtotime("+1 " . $interval, $time1); } } $count = 0; $times = array(); // Loop thru all diffs foreach ($diffs as $interval =&gt; $value) { // Break if we have needed precission if ($count &gt;= $precision) { break; } // Add value and interval // if value is bigger than 0 if ($value &gt; 0) { // Add s if value is not 1 if ($value != 1) { $interval .= "s"; } // Add value and interval to times array $times[] = $value . " " . $interval; $count++; } } // Return string with times return implode(", ", $times); } </code></pre> <p><strong>Date 1 = 2012-03-24 03:58:58<br> Date 2 = 2012-03-22 11:29:16</strong></p> <p>Is there a simple way of doing this, i.e - calculating the percentage of working hours in a week and dividing the difference using the above function - I have played around with this idea and got some very strange figures...</p> <p>Or is there better way....?</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USJohn Conde
    1. USuser1250812
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POcalc the working hours between 2 dates in PHP
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POcalc the working hours between 2 dates in PHP
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POcalc the working hours between 2 dates in PHP
      1. This table or related slice is empty.
      1. VTUpMod
    1. COYou can't do a percentage of the week kind of thing: If you have a full Saturday and Sunday, that is 0% of a work week, about 29% of a week. The fastest way to do this is to figure out the full days worked and then calculate the partial days before and after those full days worked.
      singulars
      1. POcalc the working hours between 2 dates in PHP
      1. USJerome
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload