realcutie1
New Member
- Joined
- Jul 22, 2013
- Messages
- 12
<INS style="BORDER-BOTTOM: medium none; POSITION: relative; BORDER-LEFT: medium none; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-LEFT: 0px; WIDTH: 234px; PADDING-RIGHT: 0px; DISPLAY: inline-table; HEIGHT: 60px; VISIBILITY: visible; BORDER-TOP: medium none; BORDER-RIGHT: medium none; PADDING-TOP: 0px"><INS style="BORDER-BOTTOM: medium none; POSITION: relative; BORDER-LEFT: medium none; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-LEFT: 0px; WIDTH: 234px; PADDING-RIGHT: 0px; DISPLAY: block; HEIGHT: 60px; VISIBILITY: visible; BORDER-TOP: medium none; BORDER-RIGHT: medium none; PADDING-TOP: 0px" id=aswift_0_anchor>******** style="POSITION: absolute; TOP: 0px; LEFT: 0px" id=aswift_0 vspace=0 ******="var i=this.id,s=window.google_iframe_oncopy,H=s&&s.handlers,h=H&&H,w=this.contentWindow,d;try{d=w.document}catch(e){}if(h&&d&&(!d.body||!d.body.firstChild)){if(h.call){setTimeout(h,0)}else if(h.match){w.location.replace(h)}}" height=60 marginHeight=0 frameBorder=0 width=234 allowTransparency name=aswift_0 marginWidth=0 scrolling=no hspace=0>*********></INS></INS>
Hello,
I am in logistics and I can't seem to figure out this formula in excel.
So, I have Actual Arrival times of trucks in Column E which is inputed by one of my employees. I have set up column F to display a "O" if the time is in E column is less than or equal to time in C column. It will display an "X" if it is greater than that time. I also did conditional formatting so that if it displays a "O", the cell is green and if it displays and "X", the cell is red. Only problem is that I dont want anything in the cell if nothing is input into column E. I want it to remain blank until something is entered.
<TBODY>
</TBODY>
I am in logistics and I can't seem to figure out this formula in excel.
So, I have Actual Arrival times of trucks in Column E which is inputed by one of my employees. I have set up column F to display a "O" if the time is in E column is less than or equal to time in C column. It will display an "X" if it is greater than that time. I also did conditional formatting so that if it displays a "O", the cell is green and if it displays and "X", the cell is red. Only problem is that I dont want anything in the cell if nothing is input into column E. I want it to remain blank until something is entered.
The formula I had was =IF(OR(E4<C4,E4=C4),"O","X")<C4,E4=C4),"O","X")
Column F is Green with a "O" in it if column E is blank.
Column F is Green with a "O" in it if column E is blank.
<C4,E4=C4),"O","X")
</SPAN> | Stage time</SPAN> | Window time</SPAN> | Gate Arrival</SPAN> | ARRIVAL STATUS</SPAN> | Gate Departure</SPAN> | DEPARTURE STATUS</SPAN> | |
DAY SHIFT</SPAN> | In</SPAN> | Out</SPAN> | |||||
TMMC CWDO - 03</SPAN> | 0030 - 0130</SPAN> | 500</SPAN> | 600</SPAN> | O | O | ||
TMMI IDLW - 02</SPAN> | 0030 - 0130</SPAN> | 500</SPAN> | 600</SPAN> | O | O | ||
TMMK KIPL - 02</SPAN> | 0030 - 0130</SPAN> | 600</SPAN> | 700</SPAN> | O | O | ||
SIA UDG - 01</SPAN> | 0700 - 0800</SPAN> | 800</SPAN> | 900</SPAN> | O | O | ||
TMMC CWDO - 04</SPAN> | 0800 - 0900</SPAN> | 900</SPAN> | 100</SPAN> | O | O | ||
TMMC CWDO - 05</SPAN> | 0900 - 1000</SPAN> | 1045</SPAN> | 1145</SPAN> | O | O | ||
TMMI IDAF - 01</SPAN> | 1230 - 1300</SPAN> | 1300</SPAN> | 1320</SPAN> | O | O | ||
TMMI IDLW - 03</SPAN> | 1200 - 1300</SPAN> | 1300</SPAN> | 1400</SPAN> | O | O | ||
<TBODY>
</TBODY>