OrangeViking
New Member
- Joined
- Nov 25, 2005
- Messages
- 13
I have two columns. One with a start time and one with a stop time of an activity. Both columns have the format YYYY-mm-dd hh:mm
Now I want to count the activities that were active during a specific time interval, for example between 8:00 and 9:00 but not depending on the date.
An additional challenge occurs when the activity started the previous day and finish the next.
For example.
Start 2005-12-20 22:35
Stop 2005-12-21 04:55
Now I want to count the activities that took place between 02:00 and 03:00 irrelevant of the date.
Thanks for you help!!
Now I want to count the activities that were active during a specific time interval, for example between 8:00 and 9:00 but not depending on the date.
An additional challenge occurs when the activity started the previous day and finish the next.
For example.
Start 2005-12-20 22:35
Stop 2005-12-21 04:55
Now I want to count the activities that took place between 02:00 and 03:00 irrelevant of the date.
Thanks for you help!!