How to calculate Hours between two dates?

  • Thread starter Thread starter Jon
  • Start date Start date
J

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.
 
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
 
Anwer will be in days.
Go to format | cells | number tab | custom format | [hh] | ok
 
many Thanks, It works

muddan madhu said:
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.
Click to expand...
Click to expand...
 
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?
 
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)
 
Back
Top