Hello -
I have 2 cells:
A1 is the time(text format) FROM 02:00:01 to 26:00:00.
B1 should show "LF" IF A1 is between 24:00:01 & 26:00:00, or show "PT" if A1 is between 1 9:00:01 & 24:00:00,or show "EF" if A1 is between 16:00:01 & 19:00:00, or show "DT" if A1 is between 2:00:01 & 16:00:00.
I know how to use IF somewhat, but I can't figure the logical test for a time range.
Any help would be greatly appreciated.
I have 2 cells:
A1 is the time(text format) FROM 02:00:01 to 26:00:00.
B1 should show "LF" IF A1 is between 24:00:01 & 26:00:00, or show "PT" if A1 is between 1 9:00:01 & 24:00:00,or show "EF" if A1 is between 16:00:01 & 19:00:00, or show "DT" if A1 is between 2:00:01 & 16:00:00.
I know how to use IF somewhat, but I can't figure the logical test for a time range.
Any help would be greatly appreciated.