Time interval calculation in Framework Manager

[phanicrn]

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.