Number of Hours&Minutes between Dates and time

  • Thread starter Thread starter Jeremy
  • Start date Start date
J

Jeremy

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)
 
Awesome. One other questin on the same point. If I have the Day Start at
0:00 and the day end at 24:00:00 will that account for a 24 hour work day?
 
Back
Top