If/Then Statement Help on Tardies

[squeakums]

I need help on an if/then statement. I am working with columns A and B. Column A is Actual Scheduled Time and Column B is Actual Worked Time - I need to write an if/then statement - if b1 is 1 minute or more tardy to a1 then cell will equal = 1

Thanks!

 

[VoG]

I did that in G11

<b>Sheet18</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >C</td><td >D</td><td >E</td><td >F</td><td >G</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td >Time1</td><td >Time2</td><td >D11 blk</td><td >> 1 m late</td><td >>1 h late</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td style="text-align:right; ">08:00</td><td style="text-align:right; ">09:01</td><td > </td><td style="text-align:right; ">1</td><td style="text-align:right; ">1</td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b>Spreadsheet Formulas</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >E11</td><td >=IF(AND<span style=' color:008000; '>(C11<>"",D11="")</span>,1,"")</td></tr><tr><td >F11</td><td >=IF(AND<span style=' color:008000; '>(E11="",D11-C11>1/1440)</span>,1,"")</td></tr><tr><td >G11</td><td >=IF(AND<span style=' color:008000; '>(E11="",D11-C11>1/24)</span>,1,"")</td></tr></table></td></tr></table> <br />Excel tables to the web - Excel Jeanie Html 4

 

[squeakums]

This one isn't working: =IF(AND(E11="",D11-C11>1/24),1,"")

The 24 is erroring out.