How to calculate Hours between two dates?

[Jon]

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.

 

[muddan madhu]

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

 

[muddan madhu]

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

 

[Jon]

many Thanks, It works

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

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.

 

[DAH]

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?

 

[tom confused]

How to calculate Hours between two dates?

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

 

[Daniel.C]

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

 

[Chip Pearson]

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)