Time intervals in front end

[MindaugasBacius]

Hei.

I need some help because I am struggling with this issue for a while.

I do have a data table like:

The expression is like this:

I would like to group by the results according to City. The result should be divided into hours.

My result that I wish to accomplish is like this:

If that's possible would like to get the output in front end.

Could anybody help my out?

Thank you!

[sunny_talwar · Accepted solution]

Does this look right?

[sunny_talwar]

Slight improvement of code here:

LOAD ID,

    Date2,

    Time2,

    Date1,

    Time1,

    City

FROM

[test (2).xlsx]

(ooxml, embedded labels, table is Sheet1);

Time:

LOAD Interval(TimeStamp(MakeDate(Year(Today(1)), Month(Today(1)), Day(Today(1)) + Floor(RecNo()/24)) + MakeTime(Mod(RecNo(), 24))) - Today(1)) as Time

AutoGenerate 30;

[MindaugasBacius]

Looks perfect!

Thank you a lot.

[sunny_talwar]

No problem at all