Workhours Calculation

M

Mashuganah

I need to calculate the number of work hours between a start and end time.
The task may stretch across several days, including weekends and holidays.
Only the work hours should be counted. Work hours are 8 am - 5 pm, Mon - Fri.

How can this be done?

While NETWORKDAYS provides days, I need hours.
 
M

Mike H

Why not just multiply by the hours per workday:-
=NETWORKDAYS(A1,B1,G1:G8)*9

G1 - G8 is my list of holidays

Mike
 
M

Mashuganah

Thanks Mike. However, doesn't that give me the number of hours across whole
work days? What if a task lasts 2 days and 3 hours?
 

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

Top