Sorry about the confusion
Okay - I need a if/then statement that says if C11 has something and D11 doesn't have something then = 1
C11 D11 E
8:00AM 1
Then, I need a formula that says if E is blank then use =IF(D11-C11>1/1440,1,"")
Lastly, I need a formula that says if D11-C11>1 hour then 1.
What does the 1440 stand for inthe if/then formula that you wrote by the way?
I am trying to setup different parameters for the following:
1st Formula:
Anything 1 minute over (such as lunch was 60 minutes but they took 61 minutes) = 1
2nd Formula:
Anything 1 hour and over (such as start time should be 8:00 but signed in at 9:00) = 1
3rd Formula:
1 minute or early (such as end time should be 4:30 but left at 4:29) = 1
4th Formula:
1st call in is an event – any call ins or nc/ns consecutive to that 1st day receive no additional event and call ins or nc/ns, off one day and then called in or nc/ns is only 1 event as well.