Networkdays

**MikeLevine** · Apr 5th, 2002, 05:09 AM

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** · Apr 5th, 2002, 06:21 AM

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** · Apr 5th, 2002, 06:24 AM

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/viewtop...c=4027&forum=2

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