LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AJ AJ is offline
external usenet poster
 
Posts: 99
Default workday, networkday or something else?

I have two date and time fields, the Q column is the Ordered Date and the T
colum is the Date Closed. We work 8 hours a day from 8-5. Im trying to
figure out how many hours / minutes it took someone to do the work from the
time it went ordered to the point it closed. Taking into account our work
day, which function should i use one of the ones i listed or other ones?

 
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
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
Businessday (Networkday) Function dannyboy213 Excel Discussion (Misc queries) 4 February 2nd 06 12:30 AM
Networkday Calendar rac Excel Discussion (Misc queries) 2 January 22nd 06 01:27 PM


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