+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: Libraries & Helpers (https://forum.codeigniter.com/forumdisplay.php?fid=11)
+--- Thread: Time calculation between 2 dates (/showthread.php?tid=67711)
Time calculation between 2 dates - sakthisiga - 03-30-2017
Hi Friends,
I have 2 dates with time as below:
From: 2017-03-09 09:26:00
To: 2017-03-11 09:25:00
I need to calculate exact Hour and minutes difference between 2 dates.. However I could get only 23:00 for diff functions.
I need the exact hours and minutes difference..
Please help
RE: Time calculation between 2 dates - suhindra - 03-30-2017
PHP Code:
$from = strtotime("2017-03-09 09:26:00");
$to = strtotime("2017-03-11 09:25:00");
echo round(abs($to - $from) / 60,2). " minute";
RE: Time calculation between 2 dates - dave friend - 03-30-2017
Perhaps not the most elegant - but it works.
PHP Code:
$start = new DateTime("2017-03-09 09:26:00");
$end = new DateTime("2017-03-11 09:25:00");
$interval = $start->diff($end);
$hrs = $interval->d * 24 + $interval->h;
echo $hrs." hours ".$interval->format('%i')." minutes";
RE: Time calculation between 2 dates - salain - 03-31-2017
@Dave friend solution can be slightly simplify
PHP Code:
$start = new DateTime("2017-03-09 09:26:00");
$end = new DateTime("2017-03-11 09:25:00");
$interval = $start->diff($end);
echo $interval->format('%h hours %i minutes %S seconds');
RE: Time calculation between 2 dates - dave friend - 03-31-2017
(03-31-2017, 12:14 AM)salain Wrote: @Dave friend solution can be slightly simplify
PHP Code:$start = new DateTime("2017-03-09 09:26:00");
$end = new DateTime("2017-03-11 09:25:00");
$interval = $start->diff($end);
echo $interval->format('%h hours %i minutes %S seconds');
@salain, But that won't give the right answer if the interval is more than a day. Those hours must me added to the result.
RE: Time calculation between 2 dates - salain - 03-31-2017
@Dave friend you are right, but your option would also be wrong if it is more than a month.
RE: Time calculation between 2 dates - marksman - 03-31-2017
strtotime is the best option for me
RE: Time calculation between 2 dates - dave friend - 03-31-2017
(03-31-2017, 06:10 AM)salain Wrote: @Dave friend you are right, but your option would also be wrong if it is more than a month.
An excellent point!
This revised code handles that.
PHP Code:
$start = new DateTime("2017-03-09 09:26:00");
$end = new DateTime("2017-04-09 09:26:00");
$interval = $start->diff($end);
$hrs = $interval->days * 24 + $interval->h;
echo $hrs." hours ".$interval->format('%i')." minutes";
RE: Time calculation between 2 dates - Narf - 03-31-2017
(03-31-2017, 06:17 AM)marksman Wrote: strtotime is the best option for me
strtotime() is the worst thing ever.