Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
NETWORKDAYS
Is there a way to get the difference in business hours between two dates?
Example: The difference between 10/20/2006 5:10:01 and 10/23/2006 15:10:01 would be 10:00:00, and not 82:00:00 Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
NETWORKDAYS
Correction: 34:00:00, not 10:00:00
"ansoriano1" wrote: Is there a way to get the difference in business hours between two dates? Example: The difference between 10/20/2006 5:10:01 and 10/23/2006 15:10:01 would be 10:00:00, and not 82:00:00 Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
NETWORKDAYS
=NETWORKDAYS(A1,A2)-1+MOD(A2-A1,1)
Format cell as [h]:mm:ss "ansoriano1" wrote: Is there a way to get the difference in business hours between two dates? Example: The difference between 10/20/2006 5:10:01 and 10/23/2006 15:10:01 would be 10:00:00, and not 82:00:00 Thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
NETWORKDAYS
thank you!
"Teethless mama" wrote: =NETWORKDAYS(A1,A2)-1+MOD(A2-A1,1) Format cell as [h]:mm:ss "ansoriano1" wrote: Is there a way to get the difference in business hours between two dates? Example: The difference between 10/20/2006 5:10:01 and 10/23/2006 15:10:01 would be 10:00:00, and not 82:00:00 Thanks |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
NETWORKDAYS
This will give you an incorrect result if the time in A2 is earlier in the
day than the time in A1. Try this amendment =NETWORKDAYS(A1,A2)-1+MOD(A2,1)-MOD(A1,1) note: A1 and A2 should be within business hours "Teethless mama" wrote: =NETWORKDAYS(A1,A2)-1+MOD(A2-A1,1) Format cell as [h]:mm:ss "ansoriano1" wrote: Is there a way to get the difference in business hours between two dates? Example: The difference between 10/20/2006 5:10:01 and 10/23/2006 15:10:01 would be 10:00:00, and not 82:00:00 Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining an If Statement with NETWORKDAYS function | Excel Discussion (Misc queries) | |||
networkdays vs days360 | Excel Discussion (Misc queries) | |||
networkdays function help | Excel Worksheet Functions | |||
NETWORKDAYS() not avaialbe after reopening | Excel Worksheet Functions | |||
NETWORKDAYS function problem | Excel Worksheet Functions |