Forum Discussion
Counting time periods
I have a bit of a problem: I have start and finish times and dates for operating cases over a 2 year period, I would like to count the number of cases that were ongoing during each 2 hour time period ...
=IF(L6<K6,((L6+1)-K6)*24,(L6-K6)*24)
Hope I was able to help you with this info.
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.