Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to calculate Hours between two dates?
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to calculate Hours between two dates?
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to calculate Hours between two dates?
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to calculate Hours between two dates?
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to calculate Hours between two dates?
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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel time sheet
How to calculate Hours between two dates?
EggHeadCafe - .NET Developer Portal of Choice http://www.eggheadcafe.com/default.aspx?ref=ng |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel time sheet
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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel time sheet
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
UDF To Calculate Work hours between two dates Problem with code | Excel Discussion (Misc queries) | |||
How do I calculate dates and times, w/answer of days & hours | Excel Worksheet Functions | |||
Getting and error while calculate business hours between 2 dates with holidays. | Excel Worksheet Functions | |||
Calculate work hours between two dates | Excel Worksheet Functions | |||
How do I calculate difference in days & hours between two dates e. | Excel Worksheet Functions |