Time Difference

[bluedigital]

I have a database with a Time_In and Time_Out field. How do I calculate the difference in the two times, meaning the total time of the call, and display it on a Crystal report? Any help would be appreciated

 

[Mile-O]

You would use the DateDiff() function. Look up the help files to find out the codes for the many different period types (i.e. years, months, seconds, etc.) that you can return values on.