Hospital bed occupancy serves as an important indicator of healthcare system efficiency, directly impacting patient care quality and staff workload. This study delves into the efficacy of midnight census, a conventional method for assessing bed occupancy, in supporting hospital operational planning. Historically, the midnight census has been utilised to gauge bed occupancy; however, its reliability is debated due to fluctuations throughout the day. This paper presents an analysis of 5.5 years of patient flow data from one of the hospitals in Queensland, Australia, scrutinising the statistical associations between different occupancy levels, e.g., midnight, peak, average, and minimum. The findings shed light on the efficacy of the midnight census and suggest the adoption of an hourly-based occupancy rate for more accurate capacity planning and management.