Hello forum
I need your help solving an excel question. I need a formula that will calculate the columns as follow:
If schedule date, schedule time and transmitted time columns values fall within the range of Line start date, line end date, line start time and line end time columns then show transmitted time cell is green otherwise display cell in red.
EX:
Line Start date Line end date Line start time Line end time Schedule date Schedule time Transmitted time
11/1/2019 11/3/2019 23:00:00 28:00:00 11/2/2019 23:27:05 23:27:00
Note that our hours go from 9:00 to 32:00
Can you please help me with this question? Uploaded TXT file for better viewing of the collumns
Thanks a bunch!
Marcia
Bookmarks