Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the check in time data (ex: 20:02:30) and I'm trying to group them into 15 min intervals to analyze their evolution along the day. Don't know how to fix it.... help will be very appreciated.
Thanks
Numbers like:
0,013888888888889
0,027777777777778
0,034722222222222
0,34722222222222
...
You need to format that field as you wish. Something like:
Timestamp(floor(frac([Hora])*144)/144+floor([Hora]),'M/D/YY hh:mm TT') as YourNewFieldName,