Jan 28 2020 10:06 AM
hi,
I'm trying to figure out correct formula for below table:
T1 | T2 | Priority | Difference/ format (hh:mm) | timeliness |
Date | Date | High | =b2-a2 |
|
Date | Date | Medium | =b3-a3 |
|
Date | date | Low | =b4-a4 |
|
now, in column difference I have those time differences between T2 and T1 in format hh:mm. They are connected with priority levels:
if priority "High" and difference <=00:30 - in time
if priority "High" and difference >00:30 - late
if priority "Medium" and difference <=01:30 - in time
if priority "Medium" and difference >1:30 - late
if priority "Low" and difference <=24:00 - in time
if priority "Low" and difference >24:00 - late
so as you can guess I'm looking for correct formula to put in column timeliness, which would show me if data in those lines was picked up on time or late. I was trying already with nesting other functions under if but without any luck.
Thank you in advance for any help
Jan 28 2020 10:19 AM
if priority "High" and difference <=00:30
is translated to
=IF( (C2="High")*(D2<=0.5/24), "in time", IF(...))
and use nested IF for other conditions