Grouping data in a table by time intervals

[mrtincho]

I have a table that groups calls received in a shift center with date and time in unix time format. I was able through formulas, to extract year, date and time separately. What I want to do and can not do is a table that groups me the calls received by the hour (i wanted to do 24 intervals). For example:

Interval                                                    Count calls                    Seg call               

00:00am  a 01:00 am                                   5                                      1560

01:00 am a 02:00am                                    15                                     15560

Is there any way to do that?

[Gysbert_Wassenaar]

Create an additional hour field from the time using the Hour() function.

[mrtincho]

HI, ty for the answer but  Had i table like this:

Hour                                Time call (sec)                   

01:15 am                          15 

01:27 am                           25

I want to do a table like this

Interval                        Numbers call     Time Call

00:00 a 01:00                        0                            0

01:00 a 02:00                         2                          40

etc.

Is it possible?

[Gysbert_Wassenaar]

---

@mrtincho wrote:
I have a table that groups calls received in a shift center with date and time in unix time format. I was able through formulas, to extract year, date and time separately

---

Use the Hour() function to create an additional field with the hour of the time part of the unix timestamp.