Hello, 

I’ve currently got Excel reading a list of times and plotting these times from the list into the correct category and time line, however if the start and finish times spread over 2 hours or more I need it to still read this hour between as a valid value, an example being the start time is 13:45 and the finish time is 15:23 I want excel to know that 14:00 is between these 2 times and give some kind of value, the same if the start time was 13:45 and finish time 16:10 for it to know 14:00 and 15:00 are between these times. 

my current formula which works with the times from the list is below, Red being the table of times from the list and green being the times by hour, the times on the list change daily. 

=IF(SUMIFS(AP$25:AP$45, AP$25:AP$45, “>=”&$AO12, AP$25:AP$45, “<“&$AO13),1,0)

Does any of this make sense? Top table is where its plot the start and finish times from the bottom 2 tables but its leaving the times between these 2 times blank.

​Hello,  I’ve currently got Excel reading a list of times and plotting these times from the list into the correct category and time line, however if the start and finish times spread over 2 hours or more I need it to still read this hour between as a valid value, an example being the start time is 13:45 and the finish time is 15:23 I want excel to know that 14:00 is between these 2 times and give some kind of value, the same if the start time was 13:45 and finish time 16:10 for it to know 14:00 and 15:00 are between these times.  my current formula which works with the times from the list is below, Red being the table of times from the list and green being the times by hour, the times on the list change daily.  =IF(SUMIFS(AP$25:AP$45, AP$25:AP$45, “>=”&$AO12, AP$25:AP$45, “<“&$AO13),1,0) Does any of this make sense? Top table is where its plot the start and finish times from the bottom 2 tables but its leaving the times between these 2 times blank.  Read More

​