Hours, Minutes, etc...

[techiefreak05]

If the following displays the amount of hours, how can I show minutes?

 

Code:

<?php 
$timeDiff=$r["timeDiff"]; //column that was made by subtracting SMALLER unix timestamp from LARGER timestamp.
$hoursDiff = $timeDiff / 3600;
echo $hoursDiff . " Hours Worked";
?>

 

Thanks.

[AndyB]

$timediff/60 will display the result in minutes ... but did you actually want to display hours and minutes together, e.g 4 hrs 20 mins or 4:20 or what?

[techiefreak05]

yes, something like 4hours 20 minutes.

 

I have this:

<?php

		$sqlGetDiff=mysql_query("
		SELECT ID,empID,(timeOUT - timeIN) as timeDiff 
		FROM tp2 WHERE timeIN !='' AND timeOUT !='' AND ID = $entryID 
		")

		or die(mysql_error());

while($arr=mysql_fetch_assoc($sqlGetDiff)){

	$timeDiff=$arr["timeDiff"];

	$hoursDiff = $timeDiff / 3600;
	$hoursDiff=round($hoursDiff);

	$minsDiff = $timeDiff / 60;
	$minsDiff=round($minsDiff);
	$hoursD = $hoursDiff . " Hours: " . $minsDiff . " Minutes";

}

?>