CODEWITHSUNDEEP
phptimestamp
poNgz0r
poNgz0r

Reputation: 69

Compare time difference

I want to compare the time between sent messages, so that i know how quick someone would respond.

message_sent is the unix timestamp when a message has been sent. ID: 0000000005 is the start, ID: 0000000006 is a response on the message of ID: 0000000005.

With this data: 0000000006 sent a message on 1483021773. The original question was asked in 0000000005 on 1483021687. So the reaction time is 1483021773 - 1483021687. How should i approach this so i get an average response time?

The data enter image description here

Upvotes: 1

Views: 57

Answers (2)

Pejman
Pejman

Reputation: 1358

Assuming that a response time is defined by the time it takes for a user to respond to the last message of another user:

$response_times = array(); // array of response times
// let's define a variable to keep track of the person
// to which another person will respond. initially, variable will hold
// the first message 
$initiator = array_shift($messages);
// now iterator through messages
foreach ($messages as $message) {
    // if this message belongs to the initiator, just update the timestamp
    if ($message['from_user_id'] == $initiator['from_user_id']) {
        $initiator['message_sent'] = $message['message_sent'];
        continue; // and go to the next message
    }
    // otherwise, calculate the time difference and put it in response times
    array_push($response_times, $message['message_sent'] - $initiator['message_sent']);
    // and update the initiator
    $initiator = $message;
}
// finally, calculate average of response time
$avg_response_time = array_sum($response_times) / count($response_times);

Upvotes: 1

Kaboom
Kaboom

Reputation: 684

Since i don't know the exact code here is some sudo code with an example:

$total_items = count($array_of_items);
$starting_time_total = "0";

// Some code here to do your message_sent - message_sent = $some_value;
// Do the following for every single item for the $total_items in array
$starting_time_total = $starting_time_total + $some_value;

//Now to get the average we do this
$average =  $starting_time_total / $total_items;

So if you have 4 items in the array, with response times of 423, 395, 283, 583 respectively, you are left with an average response time of 421 which you can then convert to seconds of minutes or whatever.

Upvotes: 0

Related Questions