need time function

[nezbo]

Hi

 

is there any one out there that know the best way to add 2 times together including over midnight.

 

i am using a function that adds 2 time that are during the day.

 

i am not to sure how to get it to work if i have say 18:00 to 00:30.

 

the function that i have got works with whole hours and not part hours i'e' 00:15, 00:30, 00:45.

 

please help

 

neil

<?php
//function for geting the hours of a shift.
function hoursToBeWorked($startTimeTween, $endTimeTween)
{
if ($startTimeTween >= $endTimeTween)
{
	time ($hoursWorked = ($endTimeTween + '120000') - $startTimeTween);
}
else
{
	$hoursWorked =  $endTimeTween - $startTimeTween;		
}

return $hoursWorked;
}


?>

[vijayfreaks]

Hi..

        one suggestion store time in timestamp via time() function in php and then directly do the subtraction from big to small and then use it with date() function in whichever format you want..

 

        I hope this will help you..

 

Regards,

Vijay

[nezbo]

Cheers Vijay

 

I think this would help, but i am not to sure how to use the time() stamp...

 

I have modified the function to look like this

<?php
//function for geting the hours of a shift.
function hoursToBeWorked($startTimeTween, $endTimeTween)
{
if ($startTimeTween >= $endTimeTween)
{
	$hoursWorked = ($endTimeTween + '120000') - $startTimeTween;
	$hoursWorked = $hoursWorked +10000;
}
else
{
	$hoursWorked =  $endTimeTween - $startTimeTween;	
	$hoursWorked = $hoursWorked +10000;	
}

return date("H:i:s", $hoursWorked);
}


?>

 

but it comes back with some strange figures

 

 

 

Hi..

        one suggestion store time in timestamp via time() function in php and then directly do the subtraction from big to small and then use it with date() function in whichever format you want..

 

        I hope this will help you..

 

Regards,

Vijay

[nezbo]

Hi again...

 

i have had another go and i get this

 

<?php
//function for geting the hours of a shift.
function hoursToBeWorked($startTimeTween, $endTimeTween)
{
if ($startTimeTween >= $endTimeTween)
{
	$hoursWorked = ($endTimeTween + '12000') - $startTimeTween;
}
else
{
	$hoursWorked =  $endTimeTween - $startTimeTween;	
}

return date("H:i:s", $hoursWorked);
}

$showTime = hoursToBeWorked("10:00:00", "11:00:00");

echo $showTime;
?>

 

the Result i get back is 01:00:01 and i am not to sure where the 1 second comes from.

 

Neil

[ToonMariner]

if you have enough queries left on your page I would advise that you use mysql to do this - its date manipulation support is VASTLY superior to that of php's...

[nezbo]

Cool Cheers

 

i am relitively new to PHP and SQL and i am not to sure what is ment by this, do you have any ideas of how to do it using mySQL, i have a start time and end time... so how would i use the date manipulation on SQL?

 

Neil

 

if you have enough queries left on your page I would advise that you use mysql to do this - its date manipulation support is VASTLY superior to that of php's...

[ToonMariner]

http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html - if you have a later version of mysql running thats even better mysql5 has even more datetime stuff to play with...

 

the addtime function may be of interest to you.

[nezbo]

I am really sorry about this but i am starting to tear my hear out (well i have just had it cut) about this.

 

Please could some one post some script that i can edit to fit my code and a can understand... :'(

 

I have 2 times from a table in a mySQL database and all i need it to find the difrence the time format is 24hr and 00:00:00 h:i:s there has been some talk about TIMEDIFF() and i am not to sure how to work this, and i have looked at the link that ToonMariner cindly posted and i still cant work it out...

 

Please help a man in need

 

Cheers Neil

[nezbo]

;D ;D

 

it works....

 

<?php
//function for geting the hours of a shift.
function hoursToBeWorked($startTimeTween, $endTimeTween)
{
if ($startTimeTween >= $endTimeTween)
{
	$hoursWorked =  strtotime($endTimeTween) - strtotime($startTimeTween);	
	return ($hoursWorked / 60 / 60) + 24;	
}
else
{
	$hoursWorked =  strtotime($endTimeTween) - strtotime($startTimeTween);
	return ($hoursWorked / 60 / 60);
}

}
?>;