>How about:
>SELECT SUM(CTOT(i_trn)-DTOT(TTOD(CTOT(i_trn)))) AS timesum FROM yourtable
>And to print the time:
>? TTOC(DTOT(DATE()+timesum),2)

If 4:00 was Four O'clock AM, this might work (as i understand it)

Since 4:00 denotes 4 hours, 00 minutes of time spent working, i can't assume that the date()+timesum will yield the correct time after am/pm calculations might happen.

I'm beginning to think it might be better to go into the table structure, and change this field to a seconds number rather than a character field. (i incorrectly assumed this field would never be calculated on, but simply displayed)