Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 99

networkdays issue

This is my Q838 field: 3/3/2010 4:06:08 PM
This is my T838 field: 3/3/2010 8:22:42 PM
This is my function:
=((NETWORKDAYS(Q838,T838)-1)*("10:00"-"01:00")+MOD(T838,1)-MOD(Q838,1))*24

What I get is 16:06
what I would expect to get is 4 hours 16 minutes and 34 seconds

What did I do wrong in the function to get such a difference?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
NETWORKDAYS #NAME?	Angiewelly	Excel Discussion (Misc queries)	4	April 7th 08 04:20 PM
NETWORKDAYS? Maybe not?	Ken	Excel Discussion (Misc queries)	2	March 28th 08 02:08 PM
networkdays	JK	Excel Worksheet Functions	5	May 7th 07 07:52 PM
networkdays	rsenn	Excel Worksheet Functions	0	November 24th 05 12:42 AM
NETWORKDAYS = 0	ann	Excel Discussion (Misc queries)	4	October 3rd 05 10:07 PM

All times are GMT +1. The time now is 06:42 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us