Subject Time Clock
Author Gordon Hamm
Ive got 2 fields, both of type Time

Now, I get these value.. respectivly

Time1:=TempQuery2.FieldbyName('Visit1_Time_In').AsDateTime; (val is
Time is 7:00 am)
Time2:=TempQuery2.FieldbyName('Visit1_Time_Out').AsDateTime; (val is
Time is 7:05 am)

Now, I was using a function

HowmanyMinutes:=MinutesBetween(Time2,Time1);

It returned a value of 4 minutes. Weird.

So Then I did

HowManySeconds := SecondsBetween(Time2,Time1);

And found that it returned 299 seconds (Should be 300)

Any ideas why? The value appears right in the database, but its a second off
when doing the math.