ExcelBanter - How do I calculate WORK-hours between end/start date

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I calculate WORK-hours between end/start date (https://www.excelbanter.com/excel-discussion-misc-queries/173194-how-do-i-calculate-work-hours-between-end-start-date.html)

christi

How do I calculate WORK-hours between end/start date

I need a formula to calculate WORK-hours(08:00-17:00) between end/start
date-time;
-excluding WEEKENDS
-excluding PUBLIC HOLIDAYS
cellA2 09-06-2007 09:00:00 [START DATE-TIME]
cellB2 11-06-2007 13:00:00 [END DATE-TIME]
cellC2 [HOURS:MINUTES]

All times are GMT +1. The time now is 12:35 PM.