Hi all,
Bit embarrassing that I'd need to post this.
I have thousands of date&time cells in two columns below. but the simple formula comparing one as high than the other doesnt work..! (this site won't let me post the full formula today for some reason)
<J11,"LATE","EARLY")<J11,"LATE","EARLY")
<TBODY>
</TBODY>Thanks
Bit embarrassing that I'd need to post this.
I have thousands of date&time cells in two columns below. but the simple formula comparing one as high than the other doesnt work..! (this site won't let me post the full formula today for some reason)
<J11,"LATE","EARLY")<J11,"LATE","EARLY")
target_comp_date</SPAN> | actual_comp_date</SPAN> |
15/04/2014 08:26:21</SPAN> | 31/10/2013 11:47:56</SPAN> |
30/04/2013 08:41:59</SPAN> | 03/01/2013 11:23:43</SPAN> |
30/04/2013 09:00:13</SPAN> | 03/01/2013 11:24:11</SPAN> |
15/04/2014 08:23:02</SPAN> | 31/10/2013 11:47:10</SPAN> |
<TBODY>
</TBODY>
Last edited: