Thanks Anthony, but I did not meat to investigate on a certain hour, but I needed to know which campaign that has been active for certain amount of hours. For example, I want to know which campaigns that have been running for 8 hours or more so far.
We have custom logic that calculates the campaign revenue, and we need to determine if a campaign laster certain amount of hours, before we calculate if its losing or winning.