I need to be able to Identify any times that happened within 1 hours of another on a sliding scale so If a time occured at 13:40 and one at 14:00 it would count as a 1. I can count occurances within fixed hour time ranges but I need something that can show based on a sliding range. Attached is the excel file I am working on. I highlighted the times that should be able to be found for examples
Like this?
Excel Sample.xlsx
=IF(((A3+B3)-(A2+B2))*60*24<=60,1,"") in cell C3 and dragged down will give you the 1's you can count. Still thinking about doing it as a countif in one formula.
Close. It did not account for Row 68&69.
Hi JB,
Gak67's solution works correctly. Check the workbook attached in Post #2.
If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.
If your requirement has been solved please mark your thread as Solved.
In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".
Kindly use [FORMULA] or [CODE] tags when posting your code.
Regards,
Sarang
Check the way the date is entered in B69 and make it the same as the rest.Originally Posted by jbmedic
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks