formula needed - relative reference fail

[Babbabooie]

Have a large spreadsheet that has information in half hour increments and would like to have it in hour increments.

Please see attached....

THANKS

Help.xlsx

[Ace_XL]

In H2 use

Please Login or Register  to view this content.

Copy down

[Babbabooie]

Thank You!