Doing Math with Timestamp

[jester626]

OK, got a DB with TimeIn and TimeOut Fields, they are set up as INT and am using strtotime when these fields are populated.

 

I can get the math to find out the amount of time allotted between the two times

 

<SNIPPET>

$doseconds = $row_getLastPunch['TimeOut'] - $row_getLastPunch['TimeIn']

</SNIPPET>

 

Now I know to take the number and divide by 60 to get the minutes, and then another 60 to get the hours.

 

here  is where my problem starts and my skill level stops.

 

Say I have a final answer that breaks down to 98 minutes (5880 seconds) when I go to get the hours (98 divide by 60) I get '1.6333~ hours' which is correct math, I would rather it display '1:38 hours'  or something close to that.  Any help and assistance would be greatly appreciated.

 

 

Jester

 

[Yesideez]

Try using the % operand as it will give you the remainder of a division. You can also play with floor(), ceil() and intval() to get the integer values of the division.

 

Examples:

120 % 60=0

90 % 60=30

[Yesideez]

Thinking a bit more about it I'd try something like this:

<?php
  $totalseconds=$timeout-$timein;
  $minutes=floor($totalseconds/60);
  $seconds=$totalseconds % 60);
  echo 'Time is '.$minutes.':'.$seconds;
?>

[micah1701]

echo date("H:i",$doseconds);

[Yesideez]

Hahaha how could I forget that method?

 

*oh the shame* lol

[micah1701]

when i test my own method locally i had to use gmdate() because my server is off by 7 hours. if you are getting the wrong results try:

 

<?php
echo gmdate("H:i:s",$totalseconds);
?>