Issues with time Calculation overflow error

[muppetmad]

I have two date time fields (time in and time seen) from whick I am calculating the wait time needs to be hours and minutes. This works correctly however I cannot store the data in SQL for the wait time. I know it is due to the dtatype as I am getting an overflow error. However I am not sure what the data type in SQL needs to be. OR how to handle it. Any help would be much appreciated.

 

[pbaldy]

You could use Date/Time for the difference (one Date/Time minus another results in a Date/Time value). You could also use Integer or Long, storing a common denominator of the difference (number of minutes, seconds, etc).