The problem is that it is giving the same output for every entry and doesn't return the value as "DAY" as specified by the conditions.

Yes, accident time is actual time (cell format is set to time).