You would need to use the DateDiff function. I have a report that calculates this similarly. I'm assuming the Time field is just one field. I created two fields {Login} and {Logout}. {Login} is just
{table.timefield} and {Logout} is
next{table.timefield}. Then create a field called {TotalSeconds} that is
datediff('s', {Login},{Logout}). This will give you the total seconds. You will then have to convert that into a time. I used this formula:
whileprintingrecords;
NumberVar Hours := Truncate (Remainder ({TotalSeconds} , 86400) / 3600);
NumberVar Minutes := Truncate (Remainder ({TotalSeconds} , 3600) / 60);
NumberVar Seconds := Remainder ({TotalSeconds}, 60) ;
Hours & ':' & Minutes & ':' & Seconds;
Okay, so maybe there is some easier way, but this got me the results I needed. Hope it at least helps some.
IP Logged
