Here is one method :
Formulas :
G2 : =IF(F2="","",F2-E2)
H2 : =IF(G2="","",IF(G2<(8/24),"0.5","1"))
J2 : =IF(H2="","",(G2-I2))
K2 : =IF(E2&F2="","",IF(F2="","Incomplete",IF(E2="","Incomplete","")))
ALL FORMULAS DRAG DOWN THE COLUMN
Formatting and Entries :
#2 - Columns E, F, G, I, & J are formatted as CUSTOM / [h]:mm:ss
#3 - Columns E & F must be entered as : M/D/YYYY H:MM or MM/DD/YYYY H:MM depending on the date.
#4 - Partial Hours are entered as: 0:15 for fifteen minutes, 0:30 for thirty minutes, 0:45 for 45 minutes.
#5 - If either E or F are left blank, INCOMPLETE displayed in Column K and highlighted in RED.
Concerning transferring the RAW data to the IS BLANK worksheet ... hopefully someone else can provide that answer for you.