Calculating time difference

[johnboy]

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

[a.gneady]

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.

[dallo]

thanks for the code a.gneady.

very much appreciated.

[a.gneady]

very much appreciated.

You're always welcome