Creating a roster for work and have each cell set up to say start and finish times (e.g. 0700 - 1600). Trying to create a formula to show how many people are rostered for each hour of the day to make sure there are minimum numbers rostered on for each hour. I'm using the LEFT and RIGHT functions but I'm pretty sure I'm using them all wrong. In a table further down the page on each sheet I will have the hours down the column and the days across the top row.

This is the formula I have got so far but it doesn't work. =COUNTIFS(H9:H94,(VALUE(LEFT(H9:H94, 4))=700), H9:H94,(VALUE(RIGHT(H9:H94, 4)))>800)