[RESOLVED] Readout Difference in minutes between two time values

[middleman666]

Hey All,

This is slowly driving me nuts, so bare with me..

I have two times, one is a string in this format: HH:MM:SS and the other is date('H:i:s')

I need to know the difference in minutes and then say if the difference is over 60minutes then I will delete a row from a database.

I have the following bodged together:

$date = '2008-10-22 00:55:34';  //for example sake

function distanceOfTimeInWords($fromTime, $toTime) {
	$distanceInSeconds = round($fromTime - $toTime);
	$distanceInMinutes = round($distanceInSeconds / 60);
	return $distanceInMinutes;
}

$startHour = substr($date, 11, 2);
$startMin = substr($date, 14, 2);
$startTime = strtotime($startHour.':'.$startMin.':00');
$thisTime = strtotime(date('H:i:s'));
$timeleft = 60 - distanceOfTimeInWords($startTime, $thisTime);

if ($timeleft < 0) {
     mysql_query("DELETE FROM cart WHERE id = '$CartID'");
}

I'm getting results where the $timeleft value will count down, but when it gets to 0 it will start counting up again... or it may be the other way round (sorry, I'm so tired).

Has anyone got a better way of doing this? or a solution to the above issue?

Thanks in advance for any replies.

[NogDog]

For your consideration:

$startTime = strtotime($start_time_string);
$endTime = strtotime($end_time_string);
$diffInSeconds = $endTime - $startTime;
$diffInMinutes = round($diffInSeconds / 60);

[Weedpacket]

And, unless you're a nudist, it's "bear with me" 🙂

[middleman666]

Cheers NogDog, I should really try and think more simple in the future.

It's all working now, got myself a timer to show how much of an hour is left and I'm just deleting the row when it goes over 60.

Always get confused about bear and bare, think I'll just stick with beer from now on.