Adding two times together in php

Question

I am looking to add two times together that come from a sql query. Below is my code.

$taskID = $row['taskID'];
$startTimeRaw = $row['startTime'];
$endTimeRaw = $row['endTime'];
$everyMinutesRaw = $row['everyMinutes'];
$startTime = $startTimeRaw->format('H:i:s');
$endTime = $endTimeRaw->format('H:i:s');
$everyMinutes = $everyMinutesRaw->format('H:i:s');

#$latestRunTime = $startTime;
$latestRunTimeRaw = $startTime + $everyMinutes;


echo $startTime."<BR>";
echo $everyMinutes."<BR>";
echo $latestRunTime."<BR>";

This code returns the following

06:05:00
00:15:00
6

The third line of the return should be 06:20:00, how can I make this change. I've played with strtotime and ->format() but none of it seems to get the proper answer. Thoughts?

With the data contained in the other answer I have this

$latestRunTime = strtotime($startTime) + strtotime($everyMinutes);

And it outputs

2733243600

If I format that, I get the following

Fatal error: Call to a member function format() on a non-object in

Is it possible for you to change the database query that returns this data? In that case, solve the problem by making the database do the date arithmetic for you. — mzedeler
– mzedeler, Commented Apr 22, 2013 at 17:58
Unfortunately I can't in this case. I will use this data to iterate through a loop and write to a new table — mhopkins321
– mhopkins321, Commented Apr 22, 2013 at 17:59
stackoverflow.com/questions/11720845/php-add-two-time-variables — Rachel Gallen
– Rachel Gallen, Commented Apr 22, 2013 at 17:59

Wrikken · Accepted Answer · 2013-04-22 18:27:47Z

1

This seems to be what you're after:

<?php
$period = new DatePeriod(
        new DateTime('06:05:00'),
        DateInterval::createFromDateString('15 minutes'),
        new DateTime('07:00:00'));
foreach($period as $interval){
        echo $interval->format('c').PHP_EOL;
}

Result:

2013-04-22T06:05:00+02:00
2013-04-22T06:20:00+02:00
2013-04-22T06:35:00+02:00
2013-04-22T06:50:00+02:00

You could also use new DateInterval('PT15M'), or more formally from a time:

new DateInterval('PT'.$everyMinutesRaw->format('H\Hi\Ms\S'));

If you're not interested in all the intervals but just want the first one as per your example:

 $startTimeRaw->add(new DateInterval('PT'.$everyMinutesRaw->format('H\Hi\Ms\S')));
 echo $startTimeRaw->format('H:i:s');

edited Apr 22, 2013 at 18:27

answered Apr 22, 2013 at 18:21

Wrikken

70.8k8 gold badges99 silver badges136 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

mhopkins321 Over a year ago

I had considered using dateinterval pretty strongly. The only issue is that with one query from the database, an interger of 90 might come in, signifying every 1.5 hours. And with a different query, it comes in as 01:30:00. So it is sort of a lose lose for me

Wrikken Over a year ago

Hm, if those are the only 2 formats, can you just not detect it using strstr looking for :? The very first thing to do in this scenario is to detect both inputs & convert them to a single usable known quantity.

mhopkins321 Over a year ago

Probably? I'm incredibly new to php and my curse of datetimes never working nicely seems to follow me to every language I go to

mhopkins321 Over a year ago

And those are the two formats depending on how I query the db. everyMinutes is currently stored as an integer

Wrikken Over a year ago

Well, having multiple formats will do that :P (By all means, let the user enter them however they like, but storing them in 1 predefined format if that's under your control really saves you from some headaches later on). Any way:

$datetime = new DateInterval('PT'.(strstr($string,':')!==false,DateTime::createFromFormat('H:i:s',$string)->format('H\Hi\Ms\S):$string.'M'));

would do most of the trick here (untested code..).

|

Anudeep Sharma · Accepted Answer · 2013-07-17 08:06:13Z

1

use this function

function sum_the_time($time1, $time2) {
  $times = array($time1, $time2);
  $seconds = 0;
  foreach ($times as $time)
  {
    list($hour,$minute,$second) = explode(':', $time);
    $seconds += $hour*3600;
    $seconds += $minute*60;
    $seconds += $second;
  }
  $hours = floor($seconds/3600);
  $seconds -= $hours*3600;
  $minutes  = floor($seconds/60);
  $seconds -= $minutes*60;
  if($seconds < 9)
  {
  $seconds = "0".$seconds;
  }
  if($minutes < 9)
  {
  $minutes = "0".$minutes;
  }
    if($hours < 9)
  {
  $hours = "0".$hours;
  }
  return "{$hours}:{$minutes}:{$seconds}";
}

Use this function in every where just call the function when you need..Thanks

answered Jul 17, 2013 at 8:06

Anudeep Sharma

1511 silver badge4 bronze badges

Collectives™ on Stack Overflow

Adding two times together in php

2 Answers 2

6 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related