Who knows the best way to compute the differences in two time values in
minutes?



I have the following SQL:



qryLate.SQL.Add('SELECT CAST(P.PCHIN AS TIME) AS PUNCHEDIN, S.SHIFT_BEGIN
');

.



PCHIN is a timestamp value, but I just want the time, not the date;
Shift_Begin is a Time value. I want to be able to subtract one from the
other, and get the minutes between.



Clay Shannon,

Dimension 4 Software





[Non-text portions of this message have been removed]