time difference from time stamp

Expand Post »

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]

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]

Similar Threads

SpeedUp Your Window XP Never Than Before in Windows tips 'n' tweaks
Saw this a while back - so thought I'd post it lol in IT Professionals' Lounge
Geeky Humor in Geeks' Lounge
Using a switch statement with nested if/else statements in C++

assgar

Reputation Points: 24

Solved Threads: 0

Junior Poster in Training

Offline

89 posts
since Oct 2006

Permalink

Sep 6th, 2008

Re: time difference from time stamp

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]

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]

assgar

Reputation Points: 24

Solved Threads: 0

Junior Poster in Training

Offline

89 posts
since Oct 2006

Permalink

Sep 6th, 2008

Re: time difference from time stamp

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

darkagn

Reputation Points: 395

Solved Threads: 192

Veteran Poster

Offline

1,136 posts
since Aug 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Reading the stored procedure OUT parameter in PHP

Next Thread in PHP Forum Timeline: Calling Audio Conversion Tool with PHP on Win 2003

DaniWeb Message

Cancel Changes

User Name
Password