How do I calculate the week day hours between 2 days

G

Guest

I need to calculate the difference in hours between when I received a project
and when when I completed the project. Within this time frame I do not want
to count weekends and I want the workday to be 8:00 am to 8:00 pm.

Example (9/11/5 8:00 am started and 9/12/5 8:00 am finished)= 12 hours not
24 hours

Is there an easy way to do this?
 

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

Calculate the difference betwen two columns -two dates 3
years-months-days-hours 5
How do I calculate time in excel (clock in and clock out 3
Calculating diff between date/ time only between certain hours 4
Difference of time 3
Calculate Total hours worked during workdays within given shift time. 2
Average Time for Specific Item 9
How do I format a cell to calculate overnight Hours? 7

Top