AppGini Community Forums

Posted: **2014-06-08 22:01**

Hi,

New to AppGini and PHP I need to calculate the total time for an event.

I have a start time (time field) and completion time (time field).

In the before update hook I have the following formula:

$data['TotalTime'] = $data['CompletionTime'] - $data['StartTime'];

This always gives the result -12:00:20A.

Guidance appreciated.

John

Posted: **2014-06-15 17:05**

Try:

Code: Select all

$diff_seconds = strtotime($data['CompletionTime']) - strtotime($data['StartTime']);
$data['TotalTime'] = gmdate("H:i:s", $diff_seconds);

This should work assuming both times (start and completion) are in the same day.

Posted: **2014-07-10 07:50**

thanks for the code a.gneady.

very much appreciated.

Posted: **2014-07-10 10:22**

dallo wrote:very much appreciated.

You're always welcome

AppGini Community Forums

Calculating time difference

Calculating time difference

Re: Calculating time difference

Re: Calculating time difference

Re: Calculating time difference