Well it's going to depend on what format you want to get as a result. This:

=MID(A1,5,15) &amp; " " &amp; MID(A1, 25, 4)


Would give you a result of:

Aug 01 09:08:25 2011

Just play around with MID() to get the parts that you want and use &amp; to concatenate them together in the order that you want.

Convert "Mon Aug 01 09:08:25 CDT 2011" to a usable date/time using Excel
Im trying to add 12 seconds to a mysql datetime object via php.

My php code generates the following query: "UPDATE Stats SET Usage = 1970-01-01 00:00:12" however the query fails.

My php code is as follows:

public function UpdateTime($diffrence)
{
    $seconds = $diffrence / 1000;

    mysql_connect('localhost','user','pass') or die("Unable to select host");

    mysql_select_db('StatDB') or die("Unable to select database");

    $query  = "SELECT * FROM Stats";

    $result=mysql_query($query);

    $retVal = mysql_result($result,0,"Usage");

    $oldTime = new DateTime($retVal);

    $oldTime-&gt;modify('+'. $seconds .' seconds');

    $from = date("Y-m-d H:i:s", strtotime($oldTime-&gt;format('Y-m-d H:i:s')));

    $query2  = "UPDATE Stats SET Usage = $from";
    echo $query2;

    $result2=mysql_query($query2);

    mysql_close();
}


Does anyone how I can fix this?

Thanks
