#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 93
Default NETWORKDAY

Arrive Scan Sort to Scan Index
Sort to Index QA
12/2/2008 10:15 12/2/2008 10:55 0:40 12/2/2008 11:52 0:57
QA Sort to QA HOURS
12/2/2008 13:03 1:11:00 2:48

Okay. Everything works great until a holiday or weekend gets in the mix.
I'm looking at =NETWORKDAY, but there are several problems.

....I'm wondering if the from and two dates have to be together. When I use
the formula =NETWORKDAYS(O21,U21,Holidays2009) I get 24:00 instead of 0:00.



Steph
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
workday, networkday or something else? AJ Excel Worksheet Functions 5 April 20th 10 07:46 AM
Networkday question gcw Excel Worksheet Functions 4 October 21st 08 08:19 PM
networkday - datedif BNT1 via OfficeKB.com New Users to Excel 5 April 8th 08 07:32 PM
6 day/week function ie:networkday Robert Excel Worksheet Functions 6 August 6th 07 12:06 AM
Networkday Calendar rac Excel Discussion (Misc queries) 2 January 22nd 06 01:27 PM


All times are GMT +1. The time now is 12:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"