I have a table of information that I need to simplify into a summary table.

Column B = Name
Column F= Time
Column H = Status

I need to count all of the the items that have a time of greater than 24
hours and all of the times that have a time of less than 24 hours. To
further complicate things, I need to count by individual names.

My Hope is to have the final table look something like this:

Billie (Under 24 Hours) [Number]
Billie (Over 24 Hours) [Number]

Jeremy (Under 24 Hours) [Number]
Jeremy (Over 24 hours) [Number]
There will also be names that are not on the list. I need those to return
Zero.

Please help.