Greeting,

I have two cells A1 and B1 and A1 is the start date and B1 is End Date. What
I want to do is calculating the number of hours for workers which is 8 hours
per day. How to calculate the number of Hours excluding Friday.

Excluding only friday use this formula

=SUM(IF(ISERROR(MATCH(WEEKDAY(ROW(INDIRECT(A18&":" &B18))),{6},0)),
1,0))/3

after entering the formula not just enter but use Ctrl + Shift + Enter




On Sep 10, 1:52*am, Jon wrote:
Greeting,

I have two cells A1 and B1 and A1 is the start date and B1 is End Date. What
I want to do is calculating the number of hours for workers which is 8 hours
per day. How to calculate the number of Hours excluding Friday.

What would this formula be NOT excluding Friday. Calculating exact time
(hours and minutes) between two dates being that the work week is Monday -
Friday using an 8 hour day?

"muddan madhu" wrote:

Excluding only friday use this formula

=SUM(IF(ISERROR(MATCH(WEEKDAY(ROW(INDIRECT(A18&":" &B18))),{6},0)),
1,0))/3

after entering the formula not just enter but use Ctrl + Shift + Enter




On Sep 10, 1:52 am, Jon wrote:
Greeting,

I have two cells A1 and B1 and A1 is the start date and B1 is End Date. What
I want to do is calculating the number of hours for workers which is 8 hours
per day. How to calculate the number of Hours excluding Friday.

Anwer will be in days.
Go to format | cells | number tab | custom format | [hh] | ok


On Sep 10, 1:52*am, Jon wrote:
Greeting,

I have two cells A1 and B1 and A1 is the start date and B1 is End Date. What
I want to do is calculating the number of hours for workers which is 8 hours
per day. How to calculate the number of Hours excluding Friday.

many Thanks, It works

"muddan madhu" wrote:

Anwer will be in days.
Go to format | cells | number tab | custom format | [hh] | ok


On Sep 10, 1:52 am, Jon wrote:
Greeting,

I have two cells A1 and B1 and A1 is the start date and B1 is End Date. What
I want to do is calculating the number of hours for workers which is 8 hours
per day. How to calculate the number of Hours excluding Friday.

How to calculate Hours between two dates?

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com/default.aspx?ref=ng

EndDate - BeginDate Cell Format number, Custom : [hh]
HTH
Daniel

How to calculate Hours between two dates?

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com/default.aspx?ref=ng

It depends on what you mean by "hours between dates". At its
simplest, the difference is =(EndDate - StartDate)*24. But depending
on what you actually want, there are any number of results.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Sat, 17 Jan 2009 22:23:33 -0800, tom confused wrote:

How to calculate Hours between two dates?

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com/default.aspx?ref=ng