Matching a specific date/time to the same date in a time range
Forums
I have a spreadsheet which shows dates of service and the start and end time of that service. It also shows the date and time that service was signed. I'm trying to get IDEA to match the specific signed date/time to the date of service if the time fall withing the start and end time. I've included two spreadsheets below. One show how it looks right now (2.5.2026 Example) and the other (Results) are what I'm hoping I can get it to look like in the end. I color coded the times that matched.
My original plan was to make a duplicate spreadsheet of 2.5.2026 Example and do a join function matching on the date of service and the signed date. In the Join window I wrote a script using @BetweenTime( COL_SIGNED_TIME , COL_START_TIME_MIL , END_TIME_MIL ), but the result only produced the first row because the signed time fell in between the Start/End time, even though the dates did not match.