View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jeremy Jeremy is offline
external usenet poster
 
Posts: 85
Default Number of Hours&Minutes between Dates and time

A1= 2/11/2008 13:00:00 (Monday) - Date order entered
B1= 2/12/2008 13:00:00 (Tuesday) - Fixed date to determine age of order

C1 = 24:00:00 Age of order
(This is the formula I need) I need to be able to take out weekends and
holidays.
So for the weekends

A1=2/1/08 15:00:00 (Friday) - Date order entered
B1=2/4/08 15:00:00 (Monday) Fixed date to determine age of order

C1= 24:00:00 - Age of order (Saturday and Sunday Not Counted)