On 8/2/12 05:51, "Paul Halliday" <[email protected]> wrote:
>What I have is an array of values and timestamps:
>
>17 15:31
>16 15:32
>27 15:33
>14 15:34
>11 15:35
>
>now for a day I should have 1440 entries but there could be spotty
>results, no data from say 11:59 -> 13:00.
>What I need is to sum the values for each hour interval.
I may be misinterpreting what you're asking, but what about something like
this:
$times = array(
17 => '15:31',
16 => '15:32',
27 => '15:33',
14 => '15:34',
11 => '15:35',
27 => '16:33',
14 => '17:34',
11 => '11:35',
11 => '11:36',
);
$sums = array_fill(0, 24, 0);
foreach ($times as $value => $time) {
$sums[substr($time, 0, 2)] += (integer)$value;
}
print_r($sums);
This produces:
/usr/bin/php /Volumes/Dev/Sites/playground/play4.php
Array
(
[0] => 0
[1] => 0
[2] => 0
[3] => 0
[4] => 0
[5] => 0
[6] => 0
[7] => 0
[8] => 0
[9] => 0
[10] => 0
[11] => 11
[12] => 0
[13] => 0
[14] => 0
[15] => 33
[16] => 27
[17] => 14
[18] => 0
[19] => 0
[20] => 0
[21] => 0
[22] => 0
[23] => 0
)
Process finished with exit code 0
--
Robert E. Williams, Jr.
Associate Vice President of Software Development
Newtek Businesss Services, Inc. -- The Small Business Authority
https://www.newtekreferrals.com/rewjr
http://www.thesba.com/
Notice: This communication, including attachments, may contain information that
is confidential. It constitutes non-public information intended to be conveyed
only to the designated recipient(s). If the reader or recipient of this
communication is not the intended recipient, an employee or agent of the
intended recipient who is responsible for delivering it to the intended
recipient, or if you believe that you have received this communication in
error, please notify the sender immediately by return e-mail and promptly
delete this e-mail, including attachments without reading or saving them in any
manner. The unauthorized use, dissemination, distribution, or reproduction of
this e-mail, including attachments, is prohibited and may be unlawful. If you
have received this email in error, please notify us immediately by e-mail or
telephone and delete the e-mail and the attachments (if any).
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
