My report required totalling time values past 24 hours and the source field is varchar sql 2000 8 characters and allows nulls.
I will have values listed 3 or 4 records of 99:00:00.
I need to total these records and then deduct a time value that I have pulled from a subreport.
There will also be a record that will have a null in this field in addition to the ones I wish to sum.
Total time - Time Used.
ALSO if you can answer separately how can crystal actually store timevalues larger than 23:59:59.
My current deduction value is only 15 hours for this test. But will immediately need to store larger.
Many thanks in advance