Workhours Calculation
 

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.

Workhours Calculation
 

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

G1 - G8 is my list of holidays

Mike


"Mashuganah" wrote:

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.

Workhours Calculation
 

http://www.cpearson.com/excel/DateTimeWS.htm



--
Regards,

Peo Sjoblom





"Mashuganah" wrote in message
...
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.

Workhours Calculation
 

Thanks Peo! This looks good. I'll give it a try.

"Peo Sjoblom" wrote:

http://www.cpearson.com/excel/DateTimeWS.htm



--
Regards,

Peo Sjoblom





"Mashuganah" wrote in message
...
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.

Workhours Calculation
 

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?

"Mike H" wrote:

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

G1 - G8 is my list of holidays

Mike


"Mashuganah" wrote:

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.

Workhours Calculation
 

Hello,

This might help you too:
http://www.sulprobil.com/html/count_hours.html

Regards,
Bernd