NETWORKDAYS

A

ansoriano1

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
 
A

ansoriano1

thank you!

Teethless mama said:
=NETWORKDAYS(A1,A2)-1+MOD(A2-A1,1)

Format cell as [h]:mm:ss


ansoriano1 said:
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
Click to expand...
Click to expand...
 
D

daddylonglegs

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 said:
=NETWORKDAYS(A1,A2)-1+MOD(A2-A1,1)

Format cell as [h]:mm:ss


ansoriano1 said:
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
Click to expand...
Click to expand...
 
Top