subtract times

[Anon]

hey,
Ive got these two variables that are being read from an array that comes from the database.
$resultTimesQuery[employees_time_out]
and
$resultTimesQuery[employees_time_in]
I need to calculate the time difference between these two.
I tried this:
$TotalTime = $resultTimesQuery[employees_time_out]-$resultTimesQuery[employees_time_in];
but this is giving me the hour difference, and is ignoring the minute and seconds.

anyone can help me with this??

Rooin.
p.s. both of these are stored as 'time' in the database.

[Anon]

Hi,

To work around that you need them in a solid number. Where if there is a decimal point it will take them as say 60 which would make one whole not as hours. So just do it as minutes, then just:

$dif = $in - $out;