I need help please. I need to calculate a column of data reflecting time duration. The buckets I need are 0 <=8, 8 <=16, 16 <= 24

My data is in one column and may be a duration of 0:47:08 , or 1:17:24 , etc.

So, essentially the calculation would be 0 hrs to <=8 hrs

I would then create a pivot table to sum or count each of those values per day. For example, out of 2000 jobs 345 would be between 0-8 hours, 444 between 8 and 16 hours, etc.