Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- User Start Time End Time Desired Result (license count)
- JW 03/24/2015 14:00:44 03/24/2015 14:09:57 --> 4
- TT 03/24/2015 13:58:14 03/24/2015 14:21:08 --> 3
- DQ 03/24/2015 13:53:10 03/24/2015 14:15:39 --> 3
- BB 03/24/2015 13:50:55 03/24/2015 14:20:42 --> 2
- BA 03/24/2015 13:43:02 03/24/2015 13:57:26 --> 2
- JW 03/24/2015 13:40:30 03/24/2015 13:48:38 --> 1
- BA 03/24/2015 13:18:26 03/24/2015 13:18:44 --> 1
- BA 03/24/2015 13:15:18 03/24/2015 13:15:22 --> 1
- CT 03/24/2015 11:56:55 03/24/2015 11:58:21 --> 1
- CT 03/24/2015 11:53:23 03/24/2015 11:56:55 --> 1
- CT 03/24/2015 11:51:50 03/24/2015 11:53:23 --> 1
- CT 03/24/2015 11:48:11 03/24/2015 12:16:36 --> 1
- CT 03/24/2015 11:36:54 03/24/2015 11:37:50 --> 1
- CT 03/24/2015 11:33:52 03/24/2015 11:39:38 --> 1
- CT 03/24/2015 11:31:25 03/24/2015 11:34:01 --> 1
- =COUNTIFS(B2:B$16, "<="&C2, C2:C$16, ">="&B2, A2:A$16, "<>"&A2) + 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement