Hello,
I have the =now() to show the current time in c1.
I have up to 40 different departure times for outbound shipping.
example column a1-a3
11:00 am
11:15 am
11:30 am
I would like b1-b3 to display if the load is late based on the current time. Now the issue I am having is that these time change each day so entering a hard formula 11,0,0 wouldn't work
=if(now()>a1,"late") only works once. if the time is changed is still shows late when I input a time in a1 that I know is early.
I have also tried replacing =now() with c1 and it still doesn't work.
Any help would be greatly appreciated. Happy thanksgiving
Bookmarks