DaniWeb Forum Index > Web Development > PHP

time difference from time stamp

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Oct 2006

Posts: 82

Reputation: assgar is an unknown quantity at this point

Solved Threads: 0

assgar

Offline

Junior Poster in Training

time difference from time stamp

Sep 6th, 2008

Hi

I am trying to get the number of hours and minutes between
two time time stamps.

The expected results should be 1:59 (h:mm) instead I am getting 1:58 (h:mm).
What is wrong with my approach?

Is it also possible to use a built in php function so I don't have to
divide by 60 to convert to hours and minutes?

[php]

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?
 
$end_time = "2008-09-05 20:59:13";
$start_time = "2008-09-05 19:00:16";
 
$end = date("h:i:s",strtotime($end_time));
$start = date("h:i:s",strtotime($start_time));
$diff = strtotime($end)  - strtotime($start);
 
//convert to min and sec
$convert_min = $diff/60;
$convert_sec = $diff % 60;//seconds
 
//convert to hours and min
$convert_hr = floor($convert_min/60);//hours
$remainder = floor($convert_min % 60);//minutes
 
$total_visit = 	$convert_hr.":".$remainder;	
 
?>
[/php]
<?

$end_time = "2008-09-05 20:59:13";
$start_time = "2008-09-05 19:00:16";

$end = date("h:i:s",strtotime($end_time));
$start = date("h:i:s",strtotime($start_time));
$diff = strtotime($end)  - strtotime($start);
  
//convert to min and sec
$convert_min = $diff/60;
$convert_sec = $diff % 60;//seconds

//convert to hours and min
$convert_hr = floor($convert_min/60);//hours
$remainder = floor($convert_min % 60);//minutes
	
$total_visit = 	$convert_hr.":".$remainder;	

?>
[/php]

•

Join Date: Oct 2006

Posts: 82

Reputation: assgar is an unknown quantity at this point

Solved Threads: 0

assgar

Offline

Junior Poster in Training

Re: time difference from time stamp

Sep 6th, 2008

I am getting the correct hours and minutes by removing the seconds.
E.g. date("h:i",strtotime($end_time)).
I am still open to a more efficient way to accomplish this task.

[php]

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?
 
$end_time = "2008-09-05 20:59:13";
$start_time = "2008-09-05 19:00:16";
 
$end = date("h:i",strtotime($end_time));
$start = date("h:i",strtotime($start_time));
$diff = strtotime($end)  - strtotime($start);
 
//convert to min and sec
$convert_min = $diff/60;
$convert_sec = $diff % 60;//seconds
 
//convert to hours and min
$convert_hr = floor($convert_min/60);//hours
$remainder = floor($convert_min % 60);//minutes
 
$total_visit = 	$convert_hr.":".$remainder;	
 
?>
[/php]
<?

$end_time = "2008-09-05 20:59:13";
$start_time = "2008-09-05 19:00:16";

$end = date("h:i",strtotime($end_time));
$start = date("h:i",strtotime($start_time));
$diff = strtotime($end)  - strtotime($start);
  
//convert to min and sec
$convert_min = $diff/60;
$convert_sec = $diff % 60;//seconds

//convert to hours and min
$convert_hr = floor($convert_min/60);//hours
$remainder = floor($convert_min % 60);//minutes
	
$total_visit = 	$convert_hr.":".$remainder;	

?>
[/php]

•

Join Date: Aug 2007

Posts: 793

Reputation: darkagn has a spectacular aura about

Solved Threads: 110

darkagn

Offline

Master Poster

Re: time difference from time stamp

Sep 6th, 2008

Check out the documentation on the date_sub function - I think this will do what you are after. Here is a link: http://au2.php.net/manual/en/function.date-sub.php

There are no stupid questions, only those too stupid to ask for help.
echo is a web developer's best friend.