LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default Calculating Networkdays and Business Hours

I have been trying to come up with a formula that will calculate the time
difference between two given cells. To get the correct amount of time it
takes employee's to complete the task, I must factor in networkdays and
business hours (8am-5pm). Unfortunately I have been unsuccessful in my
attempts to calculate both factors. Is there such a formula? Any help is
greatly appreciated!

09/15/06 10:05:56 09/18/06 12:15:25 - difference is ???
 
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
Another question about time and date ECLynn Excel Discussion (Misc queries) 2 August 30th 06 10:13 PM
Calculating Dates Using Different Values for NETWORKDAYS Kelly Excel Worksheet Functions 9 April 22nd 06 03:10 PM
Consecutive Days (Not NETWORKDAYS) JBarr Excel Discussion (Misc queries) 1 February 8th 06 01:11 AM
Time and Business Hours Brett Excel Worksheet Functions 1 November 23rd 05 08:20 PM
Networkdays Susan Hayes Excel Worksheet Functions 1 April 5th 05 06:33 PM


All times are GMT +1. The time now is 02:11 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"