Hi
try using the following in a helper column =FLOOR(A1,1/3) and format as time
All results as 00:00:00 are in bin1, 08:00:00 in bin 2, etc... and then create your pivot

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post