[Flynn]

I'm having an attack of The Stupids. This should be simple but I'm borking it up somewhere.

I have two dates and I'm trying to find the minutes between the dates, but only within a given month. Take these two dates:

2010-12-27 14:05:00  (Dec 27 @ 2:05 pm)
2011-01-03 17:40:00  (Jan 3 @ 5:40 pm)

I only want the time that's in January, so I clip off days before the start of the month for the first date and turn it into "2011-01-01 00:00:00"...and this is where I think I'm going wrong.

Manually counting the time for "2011-01-01 00:00:00" to "2011-01-03 17:40:00" should be 48 hours for the first two days, plus 17 hours and 40 minutes for the partial 3rd day, or 65 hours and 40 minutes, right?

48 + 17 = 65 hours, plus 40 minutes.

The problem is all of the code I've tried reports 66 hours and 40 minutes, like this function:

Code:  select

Highlight Mode: (PHP)
function dateDiff($start, $end) {
$start_time=strtotime($start);
$end_time=strtotime($end);
$diff = round(abs($end_time - $start_time) / 60, 2);
return $diff;
}
 

Several other functions give the same results: 66 hours and 40 minutes. Where oh where am I going wrong??

[UnrealEd]

I tested in my cmd window, and it returned 65 hours and 40 minutes (3940minutes)

How do you recalculate the hours and minutes based on the returned result, maybe the problem is situated there?

[phpMan2010]

Sounds like a rounding error, after the results are returned, like Ed mentioned ...

Code:  select

Highlight Mode: (PHP)
$start='2011-01-01 00:00:00'; 
$end='2011-01-03 17:40:00'; 
$start_time=strtotime($start);
$end_time=strtotime($end);
$total_seconds=abs($end_time-$start_time);
$seconds = (int)($total_seconds % 60);
$minutes = (int)(($total_seconds / 60) % 60);
$hours = (int)($total_seconds / 3600);
echo 'Integers:'.PHP_EOL;
echo $hours.':'.$minutes.':'.$seconds.PHP_EOL;
$seconds = round($total_seconds % 60);
$minutes = round(($total_seconds / 60) % 60);
$hours = round($total_seconds / 3600);
echo 'Floats:'.PHP_EOL;
echo $hours.':'.$minutes.':'.$seconds.PHP_EOL;
$seconds = floor($total_seconds % 60);
$minutes = floor(($total_seconds / 60) % 60);
$hours = floor($total_seconds / 3600);
echo 'Floats - with floor:'.PHP_EOL;
echo $hours.':'.$minutes.':'.$seconds.PHP_EOL;
 

Output

Integers:
65:40:0
Floats:
66:40:0
Floats - with floor:
65:40:0

[Flynn]

I tested in my cmd window, and it returned 65 hours and 40 minutes (3940minutes)

How do you recalculate the hours and minutes based on the returned result, maybe the problem is situated there?

Your answer helped me find it by confirming that the code *did* work...so I *knew* it had to be elsewhere. Sure enough, I had swapped two vars in an earlier revision and one of them was being totaled cumulatively. One event was an hour long and was being quietly added to the result.

Thank you for the clarity injection, lol.

[Flynn]

Your answer and Unreal Ed's answer convinced me that the problem wasn't in the place I was looking, and I ended up finding it. Thank you. (I wish this board had a "Thank You" button, I rather expect I'd be using it a lot.)