Solution to time calculations...Done

[miles_rich]

Here is the code for working out the difference between 2 dates and times. I spent ages trying to make one and i did so this is the code for it if anyone else needs it. Its very basic and no formatting but it will output the difference.

<?php

#Two dates and times to be used.
$date1 = "01/10/2002 12:00";
$date2 = "02/10/2002 13:30";

#Seperating the dates from the times.
$date1_exp = explode(" ",$date1);
$date2_exp = explode(" ",$date2);

#Working with the dates and seerating them into days / months and years.
$date1_exp1 = explode("/",$date1_exp[0]);
$date2_exp1 = explode("/",$date2_exp[0]);

#Works out the difference between the days.
$days = $date2_exp1[0] - $date1_exp1[0];
#Outputs the difference.
echo "Days Difference : $days<br>";

#Works out the difference between the months.
$mnth = $date2_exp1[1] - $date1_exp1[1];
#Outputs the difference.
echo "Mnth Difference : $mnth<br>";

#Works out the difference between the years.
$year = $date2_exp1[2] - $date1_exp1[2];
#Outputs the difference.
echo "Year Difference : $year<br>";

#Sepereates the times into hours and mins.
$time1_exp1 = explode(":",$date1_exp[1]);
$time2_exp1 = explode(":",$date2_exp[1]);

#Converts the hours to mins, then adds the rest of the mins and then converts that total into seconds.[first set of times]
$time1_hrs_mins = $time1_exp1[0]*60;
$time1_mins_secs  = $time1_hrs_mins + $time1_exp1[1];
$time1_all_secs = $time1_mins_secs*60;

#Converts the hours to mins, then adds the rest of the mins and then converts that total into seconds.[second set of times]
$time2_hrs_mins = $time2_exp1[0]*60;
$time2_mins_secs  = $time2_hrs_mins + $time2_exp1[1];
$time2_all_secs = $time2_mins_secs*60;

#Works out the difference between the seconds from the first time and the second time.
$dif =  $time2_all_secs - $time1_all_secs;

#Converts the seconds back into a time format of hours and seconds.
echo strftime("%H:%M", $dif );


?>

I hope this helps some people who had the same problems as me.

[herve]

Hi,

well, sorry to tell you that there's some bugs 🙂

for instance :

if you have :

$date1 = "31/10/2002 12:00";
$date2 = "02/11/2002 13:30";

then :

days = $date2_exp1[0] - $date1_exp1[0];
#Outputs the difference.
echo "Days Difference : $days<br>";

will output :

Days Differents : 29

the same goes for months

You should look for function like mktime() and to use
timestamp to compare two dates ; it's much more simple/sure
to code that way.

more info here :
http://www.php.net/manual/en/function.mktime.php

also :

$time1_hrs_mins = $time1_exp1[0]60;
$time1_mins_secs = $time1_hrs_mins + $time1_exp1[1];
$time1_all_secs = $time1_mins_secs60;

it's a bit strange,

if in $date2 = "02/11/2002 13:30"; 13:30 is the time, in which 13 is the hours and 30 the minutes ?

if I want to convert that in number of seconds I should do :

$time1_all_secs = ($time1_exp[0]60) + ($time_1_exp[1]3600);

Don't despair, you can't succeed if you don't try 😉 !

Regards,
Hervé.