Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a time field i wants to show time wise data with different range of time
Like
2:30 |
4:00 |
10:50 |
12:25 |
10:20 |
19:35 |
19:00 |
19:20 |
16:00 |
20:50 |
2:40 |
18:45 |
21:40 |
20:30 |
19:20 |
21:00 |
4:00 |
4:30 |
16:30 |
1:15 |
15:35 |
22:45 |
20:55 |
18:00 |
21:00 |
08:00 |
21:30 |
23:00 |
6:00 |
19:50 |
17:15 |
20:15 |
4:30 |
20:00 |
13:20 |
14:40 |
12:30 |
18:30 |
16:45 |
21:25 |
16:30 |
16:30 |
19:00 |
4:30 |
23:25 |
20:00 |
19:15 |
19:40 |
20:54 |
8:15 |
19:25 |
23:55 |
4:30 |
4:00 |
20:50 |
20:20 |
10:50 |
22:30 |
12:30 |
18:20 |
22:30 |
23:00 |
4:30 |
20:30 |
22:30 |
16:30 |
22:00 |
19:00 |
16:45 |
22:30 |
11:18 |
14:00 |
19:10 |
20:30 |
19:25 |
20:20 |
15:40 |
2:00 |
18:00 |
17:12 |
19:00 |
20:00 |
12:20 |
16:00 |
22:15 |
20:40 |
13:55 |
13:45 |
19:15 |
20:00 |
10:10 |
11:00 |
0:05 |
9:50 |
22:20 |
7:55 |
17:30 |
20:25 |
10:00 |
13:00 |
20:15 |
11:53 |
18:45 |
4:30 |
20:10 |
20:50 |
19:00 |
9:50 |
23:10 |
3:00 |
10:00 |
8:10 |
14:00 |
21:20 |
09:45 |
10:45 |
12:50 |
22:00 |
13:00 |
3:30 |
4:00 |
0:15 |
11:22 |
Since your buckets are not even in size, you may as well write this out as nested if() statements
if(Time >= '08:00' AND Time < '11:00', '8-11',
if(Time >= '11:00' AND Time < '14:00','11-14)) etc - nest as many if() statements as required.
Since your buckets are not even in size, you may as well write this out as nested if() statements
if(Time >= '08:00' AND Time < '11:00', '8-11',
if(Time >= '11:00' AND Time < '14:00','11-14)) etc - nest as many if() statements as required.