LinkBack URL
About LinkBacks
If Difference between Time 2 and Time 1 is greater than 4 minutes for one of the ID then I want to set value as 1 for Group of same ID in column E.
Please check images.
ScreenShot.JPG
I want to show 1 in column "E" Output Based on codition
If Difference between Time 2 and Time 1 is greater than 4 minutes for one of the ID then I want to set value as 1 for Group of same ID in column E.
Please check images.
ScreenShot.JPG
Try this in E3 and Drag as required
=IF(D3>0.00277777777777778,1,"")
Or
=IF(D3>TIME(0,4,0),1,"")
So 4 can be easily edited..
Last edited by NeedForExcel; 07-23-2015 at 06:09 AM. Reason: Formula Added
Cheers!
Deep Dave
untested (since you don't add an excel file).
e3 =if(sumif($a$3:$a$13,a3,$d$3:$d$13)>"0:04:00",1,"") and drag down.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hello All Thanks for your response. It helps me to some extend.
Hi,
What is it that the formula isn't giving you as per your original post?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks