Networkdays

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

Quote:

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.

IML · Apr 5th, 2002, 08:23 AM

one more link, in case you need it

http://www.mrexcel.com/board/viewtop...ic=525&forum=2

good luck

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 5th, 2002, 06:09 AM	#1
MikeLevine New Member Join Date: Apr 2002 Location: Dexter, Michigan, USA Posts: 3	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?

Apr 5th, 2002, 07:21 AM	#2
Dave Patton Board Regular Join Date: Feb 2002 Location: Calgary, Alberta Canada Posts: 2,065	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?

Apr 5th, 2002, 08:23 AM	#4
IML MrExcel MVP Join Date: Feb 2002 Location: Denver, CO Posts: 1,744	one more link, in case you need it http://www.mrexcel.com/board/viewtop...ic=525&forum=2 good luck