I have 3 columns: Start Time, Pro Clock In, Ram Clock In. I am trying to find out the # of actual minutes there are between the two clock in's. However, there are few exceptions to the calculating the minutes.
Column H (Start Time)
Column J (Pro Clock In)
Column Q (Ram Clock in)
if Q = J, then the result would be nothing (or blank)
if J is earlier than Q, then the result would be nothing
if Q is earlier than H, then I want to subtract J from H BUT if J is earlier than J return the result of nothing
if Q is later than H, I want to subtract Q, then subtract Q from J
Thanks.
Column H (Start Time)
Column J (Pro Clock In)
Column Q (Ram Clock in)
if Q = J, then the result would be nothing (or blank)
if J is earlier than Q, then the result would be nothing
if Q is earlier than H, then I want to subtract J from H BUT if J is earlier than J return the result of nothing
if Q is later than H, I want to subtract Q, then subtract Q from J
Thanks.