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

C

CHRISTI

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Determine if night shift by start & end time 2
Daily cumulative timesheet entries 0
Number of hours between now and selected date 5
Calculate elapsed time excluding specific timeframe 10
[NEWBIE] date/time diff 4
WORK HOURS DIFFERENCE BETWEEN TWO DATES 12
Average Time for Specific Item 10
Excel 2007 calculate time between 2 date/time columns 7

Top