Working in excel 2010
Looking for a formula which will show if the "Union Notification Date" in cell A2 was received prior to when the work commenced as outlined in "StartDate" cell B2 and "Start Time" cell C2.
The closest I can come up with is using: =IF(ISNUMBER(SEARCH(("*B2*"),A2)),"On Time","Late")
I think the logic is there, but perhaps the date & time formulas are causing problems.
[TABLE="class: grid, width: 500"]
<TBODY>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Union Notification Date
[/TD]
[TD]Start Date
[/TD]
[TD]Start Time
[/TD]
[TD]Late/On Time
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]10/22/2013 6:26:24 AM
[/TD]
[TD]10/22/2013
[/TD]
[TD]7:00
[/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]
Looking for a formula which will show if the "Union Notification Date" in cell A2 was received prior to when the work commenced as outlined in "StartDate" cell B2 and "Start Time" cell C2.
The closest I can come up with is using: =IF(ISNUMBER(SEARCH(("*B2*"),A2)),"On Time","Late")
I think the logic is there, but perhaps the date & time formulas are causing problems.
[TABLE="class: grid, width: 500"]
<TBODY>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Union Notification Date
[/TD]
[TD]Start Date
[/TD]
[TD]Start Time
[/TD]
[TD]Late/On Time
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]10/22/2013 6:26:24 AM
[/TD]
[TD]10/22/2013
[/TD]
[TD]7:00
[/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]