NETWORKDAYS

[Guest]

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

 

[Guest]

Correction: 34:00:00, not 10:00:00

 

[Guest]

=NETWORKDAYS(A1,A2)-1+MOD(A2-A1,1)

Format cell as [h]:mm:ss

 

[Guest]

thank you!

=NETWORKDAYS(A1,A2)-1+MOD(A2-A1,1)

Format cell as [h]:mm:ss

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

 

[Guest]

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

=NETWORKDAYS(A1,A2)-1+MOD(A2-A1,1)

Format cell as [h]:mm:ss

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