I need to convert this to military time. However - the catch - some records have nothing entered for this field.
I have tried:
Under File/ReportOptions I have marked Convert Null Values to Default
Anything that I try is kicking an error Bad Time Format String. I think it has to do with the blanks. I want to leave the field blank.
Ultimately, I need to take two fields and calculate elapsed time.