10 min time interval

[#1]

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

[#2]

Numbers like:

0,013888888888889

0,027777777777778

0,034722222222222

0,34722222222222

...

[m_woolf · Accepted solution]

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,