Hi
I have to calculate two calculations one for 1 hour interval and another for 30 minutes interval, I have column in database "HH:MM:SS" AND data represented as "03:06:51".
For example as per database coulmn i am taking Hours and minutes, but database column has Hours,minutes, seconds.let's take Transaction done between for an 30 minute travel "12:00" and 12:30and 12:30:00 to 1:00:00. Now in this caluclation i want to bring "12:00 to 12:30" and "12:30 to 1:00"I wanna create another calculation showing houlry interval 12:00 to 1:00 and 1:00 to 2:00
What functions i should use in framework manager to calculate one hour interval and 30 minute interval.