Networkdays

[MikeLevine]

The networkdays() function returns the number of whole workdays between two dates (and holidays if used). What function can I use to return the fractional portion of workdays?

 

[Dave Patton]

You can use regular arithmetic.

Start
18:00
13:00
5:00 =D4-D5

Days per Function calculation (say 4) and
regular hours per day (8)

=4*8

Does this answer your question?

 

[Ian Mac]

On 2002-04-05 05:09, MikeLevine wrote:
The networkdays() function returns the number of whole workdays between two dates (and holidays if used). What function can I use to return the fractional portion of workdays?

http://www.mrexcel.com/board/viewtopic.php?topic=4027&forum=2

might get you started, let me know if you need more.

 

[IML]

one more link, in case you need it

http://www.mrexcel.com/board/viewtopic.php?topic=525&forum=2

good luck