how to split time into 90 secs

[New123]

Hi Everyone,

I want to calculate total txns happen in every 90 sec, I was thinking is it possible to split the time into 90 secs category for entire day so that I can have total count of txns happen in 90 secs.

Thank you

[lbendlin]

You would have 24x40 units per day (960 rows).  How many days are in your calendar table?