time sheet help, format TIME and formula based on the actual time entered.

I have a few questions and hope anyone can help me with it. If you think I can be helped with macros please let me know and I’ll move my question over there.
I’m working with employee time cards, which I downloaded in excel from our program. From some reason, the values in column A and B cannot be changed to TIME format (in the ‘downloaded info’ sheet)*. The reason I need it to be time, is because I need another formula to show that if an employee clocked in after 9pm the time worked should return as 0. For ex, D2 should be 0.
Or, if the format can’t be changed, I could continue to work with the number the program give me (column C) and then add a separate formula that if the value in A2 is after 9pm, the hours worked should be 0 (it doesn’t necessarily have to change in column C, I could have it somewhere else, because In reality I’m working with 2 workbooks, one with the original info downloaded, and the second one which references all the times and I have the formulas there to calculate the pay.)
Not sure any of these are possible, but appreciate any feedback.

*I did a test (see sheet ‘test’) which I manually entered times, and then did Replace pm with space pm and that worked to change to TIME format (see sheet ‘test2’) but for the downloaded info (in the ‘downloaded info’ sheet) it’s not working.