View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
christi christi is offline
external usenet poster
 
Posts: 30
Default 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]