calculate the sum of an array of hours and minutes php

Question

Struggling with this!

I need a sum of all the diffs in php so here's the source

$du = mysql_query("select SUBTIME(timeto,timefrom) as diff from table");

while($d = mysql_fetch_assoc($du))
{

    $total[] = strtotime($d["diff"]);

}

$t = array_sum($total);

echo gmdate("H:i", $t);

Before you say it... I know I should be using PDO or mysqli

Unfortunately I need the solution in PHP

How about using mysql TIMEDIFF() – Jompper Jan 05 '14 at 14:31 — Jompper, Jan 05 '14 at 14:31

score 1 · Accepted Answer · answered Jan 05 '14 at 14:23

1

$du = mysql_query("SELECT SUM(TIME_TO_SEC(TIMEDIFF(timeto, timefrom))) AS TOTAL_SEC FROM table");

$d = mysql_fetch_assoc($du);

echo gmdate("H:i", $d["TOTAL_SEC"]);

answered Jan 05 '14 at 14:23

Simone Nigro

4,717
2
37
72

Thanks - I do need it in PHP I'll edit the OP – user3105417 Jan 05 '14 at 14:26
that was quick! thanks a lot – user3105417 Jan 05 '14 at 14:28
you're welcome... please, remember to rate answer... – Simone Nigro Jan 05 '14 at 14:36
gmdate didn't work so I used solution 2 here http://stackoverflow.com/questions/3172332/convert-seconds-to-hourminutesecond – user3105417 Jan 05 '14 at 14:39

calculate the sum of an array of hours and minutes php

1 Answers1