How do you add hours and minutes together? 1

[kaptlid]

I have rows from a mysql query in the format of HH:MM (I took out the seconds) with mysql time_format function)) what I would like to know is how to add all the times together?

1:50+
2:35+
10:10

=14:35

Thanks

 

[jpadie]

there may be a neater way of doing this:

$dbhrs = 44;
$dbmins = 255;
$time = $dbhrs + floor($dbmin/60) .':'. (($dbmins % 60) * 60);

 

[kaptlid]

foreach ($timespent as $value) { 
$dbhrs[] = intval(substr($value,0,2)); 
$dbmins[] = intval(substr($value,3)); }
$dbhr = array_sum($dbhrs);
$dbmin = array_sum($dbmins); 
$time = $dbhr + floor($dbmin/60) .':'. ($dbmin % 60);
echo $time;

I am not sure why you put the divide sign after the modulus operation, but the above works.

 

[jpadie]

there is no divide sign after the modulus operator. it is a multiplication sign.

the reason is that the modulus is based on base 10 math so you will get a decimal fraction of an hour. to make it representative of actual minutes, you need to multiply the fraction by 60.