Time difference Audit

[nickrosen28]

Hi everyone,

I have a data set that needs to be audited for time between entries. If someone has entered twice they are marked with "x" more than twice they are marked with ">2".

I am attempting to look at each person that enters more than once, and see their time between entries.

If any of there entries take place outside a 30min window of their first entry or prior entry they can be billed for both entries.

I need a formula that can look at their time of entry and compare to each entry prior; if outside 30 min mark with an x. The kicker is I am only comparing individuals vs their own times. Some will have 4 entries, some 3 and some 2.

I am lost:(

 

[BS_THE_ANALYST · Accepted solution]

@nickrosen28 hey. You just need a multi-row formula tool & leverage the datetimediff formula: