calculating average of time

[yothinker]

Hello all,

I am trying to calculated the average of time.

$t1 = '00:01:00'
$t2 = '00:02:00'

($t1+$t2) /2

Should get '00:01:30' something is wrong my code regarding a timestamp.

See below

<?

$lastvisit = strtotime('00:01:00'); // The start date becomes a timestamp
$currentdate = strtotime('00:02:00');
$difference = ($currentdate + $lastvisit)/ 2;
//$difference = ($currentdate - $lastvisit);

$hours = $difference / 3600;
$minutes = $difference / 60;
$seconds = $difference - ( intval($minutes) * 60 );
$intmin = intval($minutes);
$inthour = intval($hours);

if ($inthour == "1") { $hour = "hour"; } else { $hour = "hours"; }
if ($intmin == "1") { $minute = "minute"; } else { $minute = "minutes"; }
if ($seconds == "1") { $second = "second"; } else { $second = "seconds"; }

if ($difference < 60) { print ("Last accessed: $seconds $second ago.
\n"); }
elseif ($difference < 3600) { print ("Last accessed: $intmin $minute and $seconds $second ago.
\n"); }
elseif ($difference < 86400) { print ("Last accessed: $inthour $hour, $minutes $minute and $seconds $second ago.
\n"); }
else{
print ("Avg is: $inthour $hour, $minutes $minute and $seconds $second ago.
\n"); }
?>

The above outputs.

Avg is 293020 hours, 17581201.5 minutes and 30 seconds ago.

That's wrong! It should be Avg is 0 hours, 1 minutes and 30 seconds ago.

Any ideas?

Thanks

[bastien]

you may need to use the [man]mktime/man function

[RedDragon]

strtotime tranforms the one hour to a unix-timestamp...
a unix timestamp is the time in seconds since 01.01.1970 if i remember right, so i would suggest that

strtotime('00:01:00'); is not 1am of the 01.01.1970 but
1am of the current day or the current time+1 hour...

you might try the following:

$time = time();

$lastvisit = strtotime('00:01:00')-$time;
$currentdate = strtotime('00:02:00')-$time; 
$difference = ($currentdate + $lastvisit)/ 2; 

im very sure there are more efficient solutions...

you could also try the following (if the format of the time stays the same)

$array = explode(":", $t1);
$array2 = explode(":", $t2);

$difference = $array2[0]-$array1[0].':'.$array2[1]-$array1[1].':'.$array2[2]-$array1[2];

or something simular

[yothinker]

Thanks for replies.
They help.

I got the average function working.
I just don't understand why I need to subtract 5 from the hours?

<?

$lastvisit = strtotime('1970-01-01 20:00:00'); // The start date becomes a timestamp
$currentdate = strtotime('1970-01-01 10:00:00');

print " $lastvisit <br><br>";
print" $currentdate <br><br>";

//$difference = round(($currentdate + $lastvisit)/ 2);
//$difference = ($currentdate - $lastvisit);

//if ($currentdate > $lastvisit)
$difference =($currentdate + $lastvisit) /2;

// else
//$difference = ($lastvisit + $currentdate) /2;

$hours = floor($difference / 3600);
$remainder = $difference % 3600;
$minutes = floor($remainder / 60);
$remainder = $remainder % 60;
$seconds = $remainder;
$intmin = intval($minutes);
$inthour = intval($hours);

//floor($minutes);

//$hours = $difference % 3600;
//$minutes = $difference % 60;
//$seconds = $difference - ( intval($minutes) * 60 );
//$intmin = intval($minutes);
//$inthour = intval($hours);

if ($inthour == "1") { $hour = "hour"; } else { $hour = "hours"; }
if ($intmin == "1") { $minute = "minute"; } else { $minute = "minutes"; }
if ($seconds == "1") { $second = "second"; } else { $second = "seconds"; }

//if ($hours < 1) { $hours = 0; }

//if ($minutes < 1) { $minutes = 0; }
$hours = $hours- 5;

print ("Avg is : $hours, $minutes and $seconds ago.\n");
?>

[daveyboy]

i think you have it back to front:

$lastvisit = strtotime('1970-01-01 20:00:00'); // The start date becomes a timestamp
$currentdate = strtotime('1970-01-01 10:00:00');

$currentdate is BEFORE $lastvisit.

try:

$lastvisit = strtotime("2003-06-01 20:00:00");
$currentdate = time();

// difference in seconds (current - last, not the other way round)
$diff = $currentdate - $lastvisit;