Add timestamps to get total time

[matthewst]

I really have no idea how to even start to do this. I need to know how to add then display the the total amount of time for a given set of time stamps. For example my page looks like this:

task--------time
1-----------start at 8:00
1-----------end at 8:10
2-----------start at 8:12
3-----------start at 8:13
2-----------end at 8:14
3-----------end at 8:20
//notice there is no 8:11

I need to add then display the total amount of time it took for all tasks. Then
separate the individual tasks then figure and diaplay the total amount of time
needed for each individual task.

What I need is this:

Total Time: 19 min
task 1 10 min
task 2 2 min

task 3 7 min

task--------time
1-----------start at 8:00
1-----------end at 8:10
2-----------start at 8:12
3-----------start at 8:13
2-----------end at 8:14
3-----------end at 8:2
//notice it didn't count 8:11

$query4="SELECT * FROM job_log WHERE $table_id=table_id";

$result4=mysql_query($query4);
while ($row4 = mysql_fetch_assoc($result4))

{
$action6 = $row4['action'];
$time_table4 = $row4['time'];
$showtime2 = date('m/d/y-h:i:s',$time_table4);
	if ($showtime2=="12/31/69-06:00:00")
	$showtime2 = "No Entry";
	else
	$showtime2 = date('m/d/y-h:i:s',$time_table4);


    $query6 = "SELECT * FROM job_actions WHERE action_id = '$action6'";
    $result6 = mysql_query($query6);
    while($row6 = mysql_fetch_assoc($result6)) 
    {
          $action6 = $row6['action_name'];
if ($action6=="")
$action6 = "No Entry";
else
$action6 = $row6['action_name'];
    }

echo "<center><table border = '0' cellspaceing = '0' cellpadding = '1' width = '100%' bgcolor = '#ffffff'>";
echo "<tr><td width = '20%'>$action6</td><td align = center width = '25%'>$showtime2</td></tr>";
echo "</table></center>";
}

[Roger_Ramjet]

Help if you explained how the data is stored first.

[matthewst]

kinda new to php and mysql so i'm going to say....in a databse

here is the timestamp format:
1170096429

[Roger_Ramjet]

Well that was a helpful answer and so is this one:

[matthewst]

LOL Ha!!

It's just that I'm new to php and mysql so I don't understand what it is your asking for. I'm using a unix timestamp if that helps.

[Roger_Ramjet]

UNIX timestamp, WHY?

What I meant was how are you storing the start and end times? As columns in a row, or separate rows? What else is in the table? How do you identify end time for given start time if they are separate rows?

Basically, explain where the data comes from and how you store it. Give table schema always if you want real help. Most of us switch our mind-readers off after work.

[matthewst]

ahhhh...gotchya

here is a screen of my php page and my job_log table

there is a column for time as well as a column for action_id (start, stop, etc)
each entry has it's own row, for example:

"carol" clicks "start creation" in my php page
a record is added to the databse containing: carols id, the project id, the action being performed ( start, pause, etc), the current time
"carol" then clicks "pause creation" because it's her lunch time
a new record is added to the database containing: carols id, the project id, the action being performed ( start, pause, etc), the current time

btw: carol is an older lady who clicks the mouse button several times if something doesn't happen immediately

[Roger_Ramjet]

OK. You should be calculating the time on each task as the user enters the data. This is one place where a stored procedure would really pay off - and thus another reason to upgrade to mysql 5.0.

Since you can't do it that way, the next best alternative is a php class that needs to do the following.

1. Get the last work ticket
2. Check if it is 'open', if so, calculate the time taken and close it
3. Determine if the 'Action' entered requires a new ticket; if so input it into the table.

Doing it in a class will also allow you to trap multiple user clicks and drop them. Personally, I would also use javascript to lock the input form, or AJAX even better, so the user cannot keep on resubmitting the same data.

This is much more work up front but the payoff comes with the easier reporting afterwards: Write Once Read Many instead of having a complex query to do the time calculations every time you want a report.

As to the time itself, I doubt you want seconds taken into consideration so unix timestamp seems like overkill. Just change it to mysql datetime and round up to nearest minute.
So, add 2 column to the table: finish time and time taken, and make them default to NULL so you can use them to test if a ticket is 'open'.

[matthewst]

Ok I've been messing with this thing for over an hour. I can't figure out what I'm doing or doing wrong.

The full story. I work for a company that sell ad space on restraunt tabletops. We need a way of tracking how long it takes to put together a given ad or table. Some restraunts are more paticular than others and the longer we take the less me make (time is money). The task_id's are actually ad and table id's.

I'm not looking for someone to write the code for me but this should make things easier for anyone still willing to help me.

table_ad_time1.php

<?php
	include('include/user_check.php');
	include('include/db_con.php');
	$id = $_SESSION['track_id'];
?>

<html>
<BODY BGCOLOR=#FFFFFF leftmargin="0" marginwidth="0" topmargin="0" marginheight="0">
		<div align="center">
			<TABLE WIDTH=758 BORDER=0 CELLPADDING=0 CELLSPACING=0>
				<? include('include/top.php'); ?>
				<TR height="516">
				  <TD valign="top" height="516">
						<div align="center">

<?php

///////////// added a table id for convenience
$table_id=100581;
/////////////
$query="SELECT rest_name FROM abc_tables WHERE table_id=$table_id";
$result=mysql_query($query);
while ($row = mysql_fetch_assoc($result))
{
$rest_name = $row['rest_name'];
}
?>

<?php
echo "<center>$rest_name<br><br></center>";
echo "<center>Table ID &nbsp;#$table_id<br><br></center>";
echo "<center><table border = '1' cellspaceing = '2' cellpadding = '4' width = '100%' bgcolor = '#999999'>";
echo "<tr><td width = '40%'><font color='#ffffff'>Company Name</font></td><td width = '20%'><font color='#ffffff'>Employee Name</font></td><td width = '20%'><font color='#ffffff'>Time</font></td><td width = '25%'><font color='#ffffff'>Action</font></td></tr>";
echo "</table><br></center>";

$query4="SELECT * FROM job_log WHERE $table_id=table_id";

$result4=mysql_query($query4);
while ($row4 = mysql_fetch_assoc($result4))

{
$time_table4 = $row4['time'];
$employee_name5 = $row4['employee_id'];
$action6 = $row4['action'];
$showtime2 = date('m/d/y-h:i:s',$time_table4);
	if ($showtime2=="12/31/69-06:00:00")
	$showtime2 = "No Entry";
	else
	$showtime2 = date('m/d/y-h:i:s',$time_table4);

    $query5 = "SELECT * FROM employees WHERE employee_id = '$employee_name5'";
    $result5 = mysql_query($query5);
    while($row5 = mysql_fetch_assoc($result5)) 
    {
			$employee_name5 = $row5['fname']." ".$row5['lname'];
			if ($employee_name5=="")
			$employee_name5 = "No Entry";
			else
			$employee_name5 = $row5['fname']." ".$row5['lname'];

    }

	$query6 = "SELECT * FROM job_actions WHERE action_id = '$action6'";
    $result6 = mysql_query($query6);
    while($row6 = mysql_fetch_assoc($result6)) 
    {
             $action6 = $row6['action_name'];
			 	if ($action6=="")
				$action6 = "No Entry";
				else
				$action6 = $row6['action_name'];
    }

echo "<center><table border = '0' cellspaceing = '0' cellpadding = '1' width = '100%' bgcolor = '#ffffff'>";
echo "<tr><td align = 'center' abbr = abbr_text width = '40%'>$table_id</td><td align = 'center' width = '20%'>$employee_name5</td><td align = 'center' width = '20%'>$showtime2</td><td align = center width = '25%'>$action6</td></tr>";
echo "</table></center>";
}

$query="SELECT ad_order.company company, job_log.employee_id employee_id, job_log.time time, job_log.table_id table_id, job_log.action action FROM ad_order LEFT JOIN (job_log) ON (job_log.ad_id=ad_order.id) WHERE ad_order.cust_id=$table_id ORDER BY company,time";

$result=mysql_query($query);
while ($row = mysql_fetch_assoc($result))

{
$company = $row['company'];
$time = $row['time'];
$employee_name2 = $row['employee_id'];
$action3 = $row['action'];
$showtime = date('m/d/y-h:i:s',$time);
	if ($showtime=="12/31/69-06:00:00")
	$showtime = "No Entry";
	else
	$showtime = date('m/d/y-h:i:s',$time);


//////////////////////////////////////////////////////////////////	
//	
//	this is where i tried your code r937
//
//	
//	
//	
//	
/////////////////////////////////////////////////////////////////	



    $query2 = "SELECT * FROM employees WHERE employee_id = '$employee_name2'";
    $result2 = mysql_query($query2);
    while($row2 = mysql_fetch_assoc($result2)) 
    {
			$employee_name2 = $row2['fname']." ".$row2['lname'];
			if ($employee_name2=="")
			$employee_name2 = "No Entry";
			else
			$employee_name2 = $row2['fname']." ".$row2['lname'];

    }

	$query3 = "SELECT * FROM job_actions WHERE action_id = '$action3'";
    $result3 = mysql_query($query3);
    while($row3 = mysql_fetch_assoc($result3)) 
    {
             $action3 = $row3['action_name'];
			 	if ($action3=="")
				$action3 = "No Entry";
				else
				$action3 = $row3['action_name'];
    }

echo "<center><table border = '0' cellspaceing = '0' cellpadding = '1' width = '100%' bgcolor = '#ffffff'>";
echo "<tr><td align = 'center' abbr = abbr_text width = '40%'>$company</td><td align = 'center' width = '20%'>$employee_name2</td><td align = 'center' width = '20%'>$showtime</td><td align = center width = '25%'>$action3</td></tr><td align = 'center' abbr = abbr_text width = '40%'>$table_time4</td>";
echo "</table></center>";
}
echo "<br><br><br>";
mysql_close();
?>

</TD>
</TR>
<TR>
<TD COLSPAN=3><IMG SRC="images/inside_08.gif" WIDTH=758 HEIGHT=3></TD>
</TR>
</TABLE>
</body>
</html>

I don't need the total_table_time table to be populated but i'm sure it would be eaiser to let sql do the work then have php do it each time a page is called for.

[matthewst]

I'm so close!!!

Here's what I have now. This code will place the timestamp and action being performed between each record.

$query4="SELECT * FROM job_log WHERE $table_id=table_id";

$last_value = "";
$result4=mysql_query($query4);
while($row4 = mysql_fetch_assoc($result4)) {

///////////////////////////////////
echo "$action6  ";
	if ($action6=="Start Table PTG")
	$start_table_ptg_time = $time_table4;
echo "  $start_table_ptg_time";
//////////////////////////////////

{
$time_table4 = $row4['time'];
$employee_name5 = $row4['employee_id'];
$action6 = $row4['action'];
$showtime2 = date('m/d/y-h:i:s',$time_table4);
	if ($showtime2=="12/31/69-06:00:00")
	$showtime2 = "No Entry";
	else
	$showtime2 = date('m/d/y-h:i:s',$time_table4);

    $query5 = "SELECT * FROM employees WHERE employee_id = '$employee_name5'";
    $result5 = mysql_query($query5);
    while($row5 = mysql_fetch_assoc($result5)) 
    {
			$employee_name5 = $row5['fname']." ".$row5['lname'];
			if ($employee_name5=="")
			$employee_name5 = "No Entry";
			else
			$employee_name5 = $row5['fname']." ".$row5['lname'];

    }

	$query6 = "SELECT * FROM job_actions WHERE action_id = '$action6'";
    $result6 = mysql_query($query6);
    while($row6 = mysql_fetch_assoc($result6)) 
    {
             $action6 = $row6['action_name'];
			 	if ($action6=="")
				$action6 = "No Entry";
				else
				$action6 = $row6['action_name'];
    }

if($row['action_id'] != $last_value){ 

$last_value = $row['action_id'];
}
}

In the area between the ///// I need to do a little processing. The code that is in there now is just for s and g's. Instead of just placing the timestamp and action between each record I need to store the timestamp and action in a veriable. Then (probably with an if statement) do something like "if $action=start_1 then go to the next record with same employee_id and task_id and that has an action of stop_1 then do the math then display the result".

[matthewst]

baby steps

$query4="SELECT * FROM job_log WHERE $table_id=table_id";

$last_value = "";
$result4=mysql_query($query4);
while($row4 = mysql_fetch_assoc($result4)) {

if ($action6=="Start Outside Change"){
$start_action = $action6;
$start_outside_change = $time_table4;}

	elseif ($action6=="End Outside Change"){
	$end_action = $action6;
	$end_outside_change = $time_table4;
	$total_time = $end_outside_change - $start_outside_change;
	$total_time1 = date('h:i:s',$total_time);
	echo "$total_time1";}

else
echo "";

{
$time_table4 = $row4['time'];
$employee_name5 = $row4['employee_id'];
$action6 = $row4['action'];
$showtime2 = date('m/d/y-h:i:s',$time_table4);
	if ($showtime2=="12/31/69-06:00:00")
	$showtime2 = "No Entry";
	else
	$showtime2 = date('m/d/y-h:i:s',$time_table4);

    $query5 = "SELECT * FROM employees WHERE employee_id = '$employee_name5'";
    $result5 = mysql_query($query5);
    while($row5 = mysql_fetch_assoc($result5)) 
    {
			$employee_name5 = $row5['fname']." ".$row5['lname'];
			if ($employee_name5=="")
			$employee_name5 = "No Entry";
			else
			$employee_name5 = $row5['fname']." ".$row5['lname'];

    }

	$query6 = "SELECT * FROM job_actions WHERE action_id = '$action6'";
    $result6 = mysql_query($query6);
    while($row6 = mysql_fetch_assoc($result6)) 
    {
             $action6 = $row6['action_name'];
			 	if ($action6=="")
				$action6 = "No Entry";
				else
				$action6 = $row6['action_name'];
    }

if($row['action_id'] != $last_value){ 

$last_value = $row['action_id'];
}
}

that code will generate this:
100621 Dawn Justice 03/05/07-08:49:50 End Outside Change
----------------06:06:04---------------------
6 hours 6 minutes 4 seconds

what i need is:
100621 Dawn Justice 03/05/07-08:49:50 End Outside Change
----------------06:04---------------------
this outside change only took 6 min 4 sec

however some times wil be in the hours (2:15:12 ---2 hours 15 min 12 sec)

[matthewst]

$total_time1 is returning "the time" not an amount of time.

In my code the result is 06:25:09-----(6:25 AM or PM)
What I need is the amount of time passed between $start and $end_outside_change which 25 min 9 sec

$total_time = $end_outside_change - $start_outside_change;
$total_time1 = date('h:i:s',$total_time);
echo "$total_time1";

[matthewst]

as it turns out, i'm retarted.

cfw (codewalkers) wrote this for me

$query4="SELECT * FROM job_log WHERE $table_id=table_id";

$last_value = "";
$result4=mysql_query($query4);
while($row4 = mysql_fetch_assoc($result4)) {

if ($action6=="Start Outside Change"){
$start_action = $action6;
$start_outside_change = $time_table4;}

	elseif ($action6=="End Outside Change"){
	$end_action = $action6;
	$end_outside_change = $time_table4;
	$sec = $end_outside_change - $start_outside_change;
	$hr = floor($sec/60/60);
	$sec = $sec - $hr * 60 * 60; 
	$min = floor($sec/60); 
	$sec = $sec - $min * 60;
	$total_time = sprintf("%02d:%02d:%02d", $hr, $min, $sec); 
	echo "$total_time";}

else
echo "";

[matthewst]

How would I handle a pause/resume situation?

I'm currently trying to get this to work(no success yet):

if ($action6=="Start Table PTG"){
	$start_action = $action6;
	$start_table_ptg = $time_table4;}

	elseif ($action6=="Pause"){
	$pause_action = $action6;
	$pause_table_ptg = $time_table4;}

	elseif ($action6=="Resume"){
	$resume_action = $action6;
	$resume_table_ptg = $time_table4;
	$sec = $pause_table_ptg - $resume_table_ptg;
	$hr = floor($sec/60/60);
	$sec = $sec - $hr * 60 * 60; 
	$min = floor($sec/60); 
	$sec = $sec - $min * 60;
	$pause_time = sprintf("%02d:%02d:%02d", $hr, $min, $sec);}

	elseif ($action6=="Finish Table PTG"){
	$end_action = $action6;
	$end_table_ptg = $time_table4;
	$sec = $end_table_ptg - $start_table_ptg - $pause_time;
	$hr = floor($sec/60/60);
	$sec = $sec - $hr * 60 * 60; 
	$min = floor($sec/60); 
	$sec = $sec - $min * 60;
	$total_time = sprintf("%02d:%02d:%02d", $hr, $min, $sec); 
	echo "$total_time";}

else
echo "";

The elasped time shows 02:09:42, which is correct when not counting the pause. Counting the pause it should be 01:53:48.

[matthewst]

I'm an idiot. If I echo $soft_stop_time or $soft_start_time in their respective {}'s I get the correct number of seconds. If I echo $soft_stop_time or $soft_start_time (or $total_time for that matter) in the table where it's supposed to be I get nothing. Where do I go from here? How do I "move" veriables from one set of {}'s to another?

if ($action6=="Start Table PTG"){
	$start_table_ptg = $time_table4;}


	elseif ($action6=="Pause"){
	$pause_table_ptg = $time_table4;		
	$soft_stop_time = $pause_table_ptg - $start_table_ptg;}

	elseif ($action6=="Resume"){
	$soft_start_time = $time_table4;}

	elseif ($action6=="Finish Table PTG"){
	$end_table_ptg = $time_table4;
	$soft_end_time = $end_table_ptg - $soft_start_time;}

	elseif ($action6=="Finish Table PTG"){
	$end_table_ptg = $time_table4;
	$sec = $end_table_ptg - $start_table_ptg;
	$hr = floor($sec/60/60);
	$sec = $sec - $hr * 60 * 60; 
	$min = floor($sec/60); 
	$sec = $sec - $min * 60;
	$total_time = sprintf("%02d:%02d:%02d", $hr, $min, $sec); 
	echo "<center><table border = '0' cellspaceing = '0' cellpadding = '-1' width = '10%' bgcolor = '#999999'>";
	echo "<tr><td align = 'center' width = '100%'>$soft_end_time</td>";
	echo "</tr></table></center>";}


else
echo ""

[matthewst]

I am having diffuculty accounting for pauses. Does anyone have any ideas on how to remove the paused time from my $total_time?

$query4="SELECT * FROM job_log WHERE $table_id=table_id";

$last_value = "";
$result4=mysql_query($query4);
while($row4 = mysql_fetch_assoc($result4)) {

if ($action6=="Start Creation"){
$start_creation = $time_table4;}
if ($action6=="Start Table PTG"){
$start_table_ptg = $time_table4;}
if ($action6=="Cutting - Begin"){
$start_cutting_begin = $time_table4;}
if ($action6=="Begin 1st Proof"){
$start_begin_proof = $time_table4;}
if ($action6=="Proof Print - Begin"){
$start_print_proof_begin = $time_table4;}
if ($action6=="Start In-House Fix"){
$start_inhouse_fix = $time_table4;}
if ($action6=="Final Print - Begin"){
$start_final_print_begin = $time_table4;}
if ($action6=="Start Outside Change"){
$start_outside_change = $time_table4;}

	elseif ($action6=="End Creation"){
	$end_creation = $time_table4;
	$sec = $end_creation - $start_creation;
	$hr = floor($sec/60/60);
	$sec = $sec - $hr * 60 * 60; 
	$min = floor($sec/60); 
	$sec = $sec - $min * 60;
	$total_time = sprintf("%02d:%02d:%02d", $hr, $min, $sec); 
	echo "<center><table border = '0' cellspaceing = '0' cellpadding = '-1' width = '10%' bgcolor = '#999999'>";
	echo "<tr><td align = 'center' width = '100%'>$total_time</td>";
	echo "</tr></table></center>";}

	elseif ($action6=="Finish Table PTG"){
	$end_table_ptg = $time_table4;
	$sec = $end_table_ptg - $start_table_ptg;
	$hr = floor($sec/60/60);
	$sec = $sec - $hr * 60 * 60; 
	$min = floor($sec/60); 
	$sec = $sec - $min * 60;
	$total_time = sprintf("%02d:%02d:%02d", $hr, $min, $sec); 
	echo "<center><table border = '0' cellspaceing = '0' cellpadding = '-1' width = '10%' bgcolor = '#999999'>";
	echo "<tr><td align = 'center' width = '100%'>$total_time</td>";
	echo "</tr></table></center>";}

	elseif ($action6=="Cutting - End"){
	$end_cutting_end = $time_table4;
	$sec = $end_cutting_end - $start_cutting_begin;
	$hr = floor($sec/60/60);
	$sec = $sec - $hr * 60 * 60; 
	$min = floor($sec/60); 
	$sec = $sec - $min * 60;
	$total_time = sprintf("%02d:%02d:%02d", $hr, $min, $sec); 
	echo "<center><table border = '0' cellspaceing = '0' cellpadding = '-1' width = '10%' bgcolor = '#999999'>";
	echo "<tr><td align = 'center' width = '100%'>$total_time</td>";
	echo "</tr></table></center>";}

	elseif ($action6=="End 1st Proof -OK"){
	$end_proof_ok = $time_table4;
	$sec = $end_proof_ok - $start_begin_proof;
	$hr = floor($sec/60/60);
	$sec = $sec - $hr * 60 * 60; 
	$min = floor($sec/60); 
	$sec = $sec - $min * 60;
	$total_time = sprintf("%02d:%02d:%02d", $hr, $min, $sec); 
	echo "<center><table border = '0' cellspaceing = '0' cellpadding = '-1' width = '10%' bgcolor = '#999999'>";
	echo "<tr><td align = 'center' width = '100%'>$total_time</td>";
	echo "</tr></table></center>";}

	elseif ($action6=="End 1st Proof - FIX"){
	$end_proof_fix = $time_table4;
	$sec = $end_proof_fix - $start_begin_proof;
	$hr = floor($sec/60/60);
	$sec = $sec - $hr * 60 * 60; 
	$min = floor($sec/60); 
	$sec = $sec - $min * 60;
	$total_time = sprintf("%02d:%02d:%02d", $hr, $min, $sec); 
	echo "<center><table border = '0' cellspaceing = '0' cellpadding = '-1' width = '10%' bgcolor = '#999999'>";
	echo "<tr><td align = 'center' width = '100%'>$total_time</td>";
	echo "</tr></table></center>";}

	elseif ($action6=="Proof Print - Finish"){
	$end_print_proof_finish = $time_table4;
	$sec = $end_print_proof_finish - $start_print_proof_begin;
	$hr = floor($sec/60/60);
	$sec = $sec - $hr * 60 * 60; 
	$min = floor($sec/60); 
	$sec = $sec - $min * 60;
	$total_time = sprintf("%02d:%02d:%02d", $hr, $min, $sec); 
	echo "<center><table border = '0' cellspaceing = '0' cellpadding = '-1' width = '10%' bgcolor = '#999999'>";
	echo "<tr><td align = 'center' width = '100%'>$total_time</td>";
	echo "</tr></table></center>";}

	elseif ($action6=="End In-House Fix"){
	$end_inhouse_fix = $time_table4;
	$sec = $end_inhouse_fix - $start_inhouse_fix;
	$hr = floor($sec/60/60);
	$sec = $sec - $hr * 60 * 60; 
	$min = floor($sec/60); 
	$sec = $sec - $min * 60;
	$total_time = sprintf("%02d:%02d:%02d", $hr, $min, $sec); 
	echo "<center><table border = '0' cellspaceing = '0' cellpadding = '-1' width = '10%' bgcolor = '#999999'>";
	echo "<tr><td align = 'center' width = '100%'>$total_time</td>";
	echo "</tr></table></center>";}

	elseif ($action6=="Final Print - End"){
	$end_final_print_end = $time_table4;
	$sec = $end_final_print_end - $start_final_print_begin;
	$hr = floor($sec/60/60);
	$sec = $sec - $hr * 60 * 60; 
	$min = floor($sec/60); 
	$sec = $sec - $min * 60;
	$total_time = sprintf("%02d:%02d:%02d", $hr, $min, $sec); 
	echo "<center><table border = '0' cellspaceing = '0' cellpadding = '-1' width = '10%' bgcolor = '#999999'>";
	echo "<tr><td align = 'center' width = '100%'>$total_time</td>";
	echo "</tr></table></center>";}

	elseif ($action6=="End Outside Change"){
	$end_outside_change = $time_table4;
	$sec = $end_outside_change - $start_outside_change;
	$hr = floor($sec/60/60);
	$sec = $sec - $hr * 60 * 60; 
	$min = floor($sec/60); 
	$sec = $sec - $min * 60;
	$total_time = sprintf("%02d:%02d:%02d", $hr, $min, $sec); 
	echo "<center><table border = '0' cellspaceing = '0' cellpadding = '-1' width = '10%' bgcolor = '#999999'>";
	echo "<tr><td align = 'center' width = '100%'>$total_time</td>";
	echo "</tr></table></center>";}

else{
echo "";}

I need something along the lines of "if task had a pause then find resume for that task and subtract the amount of paused time"

[matthewst]

Thanks again to cfw.

I was able to put your code to good use. The page loads alot faster! The pause and resume times are now correct but I still can't figure out how to add them to get the correct amount of $total_time.

if ($action3=="Start Creation" || $action3=="Start Table PTG" || $action3=="Cutting - Begin" || $action3=="Begin 1st Proof" || $action3=="Proof Print - Begin" || $action3=="Start In-House Fix" || $action3=="Final Print - Begin" || $action3=="Start Outside Change" || $action3=="Start Outside Fix" || $action3=="Resume"){
	$start_action = $time;}

	elseif ($action3=="End Creation" || $action3=="Finish Table PTG" || $action3=="Cutting - End" || $action3=="End 1st Proof -OK" || $action3=="End 1st Proof - FIX" || $action3=="End In-House Fix" || $action3=="Final Print - End" || $action3=="End Outside Change" || $action3=="End Outside Fix" || $action3=="Pause"){
	$end_action = $time;
	$sec = $end_action - $start_action;
	$hr = floor($sec/60/60);
	$sec = $sec - $hr * 60 * 60; 
	$min = floor($sec/60); 
	$sec = $sec - $min * 60;
	$total_time = sprintf("%02d:%02d:%02d", $hr, $min, $sec); 
	echo "<center><table border = '0' cellspaceing = '0' cellpadding = '-1' width = '10%' bgcolor = '#999999'>";
	echo "<tr><td align = 'center' width = '100%'>$total_time</td>";
	echo "</tr></table></center>";}

else{
echo "";}

In the attachment I need to add 25:47 and 1:28:01 and make that the new $total_time.