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

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

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

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

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