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.