smellyalater
Registered User.
- Local time
- Yesterday, 22:57
- Joined
- Mar 21, 2016
- Messages
- 16
Hi guys
I was advised to come to this part of the forum as |I would love to do this through VBA:
These are my before and after code is ran table:
ID, mobile, datetime, unique
1, 07712312312, 14/04/2016 13:02:34, blank
2, 07712312312, 14/04/2016 13:21:13, blank
3, 07712312312, 14/04/2016 13:23:56, blank
4, 07712312312, 14/04/2016 13:02:34, blank
I want to get this:
ID, mobile, datetime, unique
1, 07712312312, 14/04/2016 13:02:34, blank
2, 07712312312, 14/04/2016 13:21:13, 1
3, 07712312312, 14/04/2016 13:23:56, 0
4, 07712312312, 14/04/2016 13:52:34, 1
I want to use vba to do a datediff to make sure there is 15 minutes between each number coming in, so that it is unique again and gets a 1. If it is less than 15 minutes then it is not classed as unique therefore gets a 0, then move the the next number do the checks and put the values in.
Hope this makes sense any help or good examples to follow would be great
Thanks!
I was advised to come to this part of the forum as |I would love to do this through VBA:
These are my before and after code is ran table:
ID, mobile, datetime, unique
1, 07712312312, 14/04/2016 13:02:34, blank
2, 07712312312, 14/04/2016 13:21:13, blank
3, 07712312312, 14/04/2016 13:23:56, blank
4, 07712312312, 14/04/2016 13:02:34, blank
I want to get this:
ID, mobile, datetime, unique
1, 07712312312, 14/04/2016 13:02:34, blank
2, 07712312312, 14/04/2016 13:21:13, 1
3, 07712312312, 14/04/2016 13:23:56, 0
4, 07712312312, 14/04/2016 13:52:34, 1
I want to use vba to do a datediff to make sure there is 15 minutes between each number coming in, so that it is unique again and gets a 1. If it is less than 15 minutes then it is not classed as unique therefore gets a 0, then move the the next number do the checks and put the values in.
Hope this makes sense any help or good examples to follow would be great
Thanks!