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?
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?
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?
http://www.mrexcel.com/board/viewtop...c=4027&forum=2On 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?
might get you started, let me know if you need more.
"Have a good time......all the time"
Ian Mac
Like this thread? Share it with others