I can't quite remember the specifics in play here but suspect the previous approach was somewhat over complicated -- issue arising from the 0&value and FLOOR, e.g
the 0& was prefixed to handle blanks whilst avoiding array-entry requirement (c/o IF)
the above coupled with existing calc logic:
the original calculation identifies rows where entire hour worked then adds any row where either start/end occur within the hour... i.e. = x + y
means the record is added twice over, once within the "x" section and then, again, within the "y" section (referring to earlier post)
so, referring back to over-complication, if start/end on the hour are included -- i.e. a start at 08:00 and end at 12:00 would result in being included for hours 8-12 inclusive, then perhaps below will suffice?
Bookmarks