I have Episodes.textTimeColl which is a text field string (4 characters long) that I am converting to time using the following formula Time Coll Format:

CTime(Picture({Episodes.textTimeColl}, "xx:xx"))

Then I take @Time Coll Format and use it for this calculation TAT External:

TAT Coll Format and TAT External display on the report.

I need to introduce an IF statement when Episodes.textTimeColl = "0000" (4 zeros) for two purposes:
1. Time Coll Format display as "Not Given"
2. Stop the TAT External calculation from taking place

I tried combining the IF statement with the @Time Coll Format calculation with no success. Where would be the best place to introduce the IF Statement? What would be the correct syntax?