Thread: Calculating Business Hours Between 2 Dates
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
vezerid
 
Posts: n/a
Default Calculating Business Hours Between 2 Dates
Tanya,
try this:

=NETWORKDAYS(IF(MOD(A2,1)17/24,A2+1,A2),B2)-1-IF(MOD(A2,1)17/24,7/24,MOD(A2,1))+MOD(B2,1)

HTH
Kostis Vezerides

Reply With QuoteReply With Quote