LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Susan Hayes
 
Posts: n/a
Default Help on Networkdays

I'm trying to find the number of business (working) days between two dates.
I am using the Networkdays function however it returns the number of whole workdays between two dates. Eg. 1.00 or 2.00
or 3.00
I need fractional days in order to denote a certain time of day.

Eg.

Start date: Friday, September 2, 2005
End date: Wednesday, September 7, 2005

Holidays: Labour Day: September 5, 2005

The answer received is 3.00

However I need to set a time as of 3:00 pm on September 7 for example.

Start date: Friday, September 2 1
Tuesday, September 6 1
Current date Wednesday, Septmeber 7 15/24

Total 2..625


Thank you

Susan
 
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
NETWORKDAYS() not avaialbe after reopening Stan Excel Worksheet Functions 2 June 19th 05 04:53 PM
NETWORKDAYS gives #NAME even though Analysis Toolpak is installed Stan Brown Excel Worksheet Functions 15 June 10th 05 04:33 PM
NETWORKDAYS function problem Arvi Laanemets Excel Worksheet Functions 5 April 19th 05 08:10 AM
Networkdays shows as #NAME even though I have the toolpack instal. mark Excel Discussion (Misc queries) 1 December 1st 04 09:13 PM
MS Excel Function - Networkdays Nilesh Inamdar Excel Worksheet Functions 3 November 26th 04 07:10 PM


All times are GMT +1. The time now is 04:24 PM.

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

About Us

"It's about Microsoft Excel"