View Single Post
  #1  
Old April 14th, 2010, 03:08 PM posted to microsoft.public.excel.worksheet.functions
aj
external usenet poster
 
Posts: 333
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?